Posted
by Luca Romagnoli
on Stack Overflow
See other posts from Stack Overflow
or by Luca Romagnoli
Published on 2010-03-15T11:33:21Z
Indexed on
2010/03/15
11:39 UTC
Read the original article
Hit count: 219
is possible do a case in a group by? similar to this:
select * from table
GROUP BY
CASE WHEN @Attivita=0 THEN (RANK() OVER (GROUP BY Nome,AccountID,Matricola DESC))
END
thanks
© Stack Overflow or respective owner
as seen on ASP-PHP.net
- Search for 'ASP-PHP.net'
Modification technique pour le site de l'article.
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server.
My main concern is deploying schema + data updates to developer machines from the "master" development…
>>> More
as seen on Internet.com
- Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
I have recently been looking at the latest release of the BPM Case Management feature in the Oracle BPM PS6 release. I had put together some…
>>> More
as seen on Super User
- Search for 'Super User'
Hello,
I have about 2k of file that are currently in lower case like:
file_one.cfr
file_two.cfr
....
I am searching for a fast way to rename them to upper case so they would be like;
FILE_ONE.cfr
FILE_TWO.cfr
....
If I use from my shell;
for i in *; do mv $i `echo $i | tr [:lower:] [:upper:]`;…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
I have about 2k of file that are currently in lower case like:
file_one.cfr
file_two.cfr
....
I am searching for a fast way to rename them to upper case so they would be like;
FILE_ONE.cfr
FILE_TWO.cfr
....
If I use from my shell;
for i in *; do mv $i `echo $i | tr [:lower:] [:upper:]`;…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
is the best/cleanest way to just do a for loop iterating through each position and call tolower() on it?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
What am i doing wrong here? I want the users name to be shown in the output as propercase but I cant figure it out.
string proper = this.xTripNameTextBox.Text;
CultureInfo properCase = System.Threading.Thread.CurrentThread.CurrentCulture;
TextInfo currentInfo = properCase.TextInfo;
proper = currentInfo…
>>> More
