Viewing 15 posts - 5,791 through 5,805 (of 15,381 total)
Here is a script that was posted by ChrisM. I modified it slightly to make a little more bullet proof. This will generate the code you need to run. It...
February 3, 2014 at 7:55 am
pietlinden (2/2/2014)
Definitely need an ORDER BY clause! TOP VALUES without...
February 3, 2014 at 7:47 am
elham_azizi_62 (2/3/2014)
I am in hurry and I don't have time and I have to give it to my boss immediately.please help me.
We are not here to be unpaid consultants. We...
February 3, 2014 at 7:26 am
StarNamer (2/3/2014)
You say 'personally prefer' - how does your solution compare to PIVOTs for performance on large result sets?
It will pretty much always outperform a traditional PIVOT. See this article...
February 3, 2014 at 7:15 am
Steve Jones - SSC Editor (1/31/2014)
January 31, 2014 at 3:56 pm
Nice work Alan. I too suspected that an inner join could (and probably will) not produce exactly the right results. Of course in our business accuracy is the first requirement....
January 31, 2014 at 3:00 pm
sqldriver (1/31/2014)
I've been writing queries using
SUM(CASE WHEN SomeVal = 'X' THEN 1 ELSE 0 END)
And today looking at some code I saw someone do
CASE WHEN SomeVal =...
January 31, 2014 at 2:41 pm
Luis Cazares (1/31/2014)
It's more like:
SELECT fname, lname, MAX(location1), MAX(location2)
FROM #Something
GROUP BY fname, lname
Probably true. I didn't put much into since it is late on Friday afternoon. 😛
January 31, 2014 at 2:30 pm
Not 100% certain what you are looking for as you didn't post a lot of details. It would be very helpful if you could post ddl and sample data in...
January 31, 2014 at 2:10 pm
hayden_jones (1/31/2014)
I log in to windows as DOMAINA.userA and open SSMS using...
January 31, 2014 at 12:06 pm
hayden_jones (1/31/2014)
January 31, 2014 at 9:59 am
Research, analysis, testing.
There is no "easy" way to do this and each one requires a unique process to remove it. They just have to be dealt with one at a...
January 31, 2014 at 9:44 am
VoldemarG (1/31/2014)
2) where databasename ='myDBname'
and applicationname...
January 31, 2014 at 9:43 am
wolfkillj (1/31/2014)
Ed Wagner (1/31/2014)
Luis Cazares (1/30/2014)
Would this help?http://www.sqlskills.com/blogs/kimberly/guids-as-primary-keys-andor-the-clustering-key/
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/guid-vs-int-debate.aspx
Maybe even a post from a GUID lover:
http://blogs.msdn.com/b/sqlazure/archive/2010/05/05/10007304.aspx
Or even BOL on Using uniqueidentifier Data:
http://technet.microsoft.com/en-us/library/ms190215(v=sql.105).aspx
I especially like Kimberly's article Luis posted here. Sean,...
January 31, 2014 at 9:40 am
damcguire (1/31/2014)
January 31, 2014 at 9:01 am
Viewing 15 posts - 5,791 through 5,805 (of 15,381 total)