Viewing 15 posts - 4,276 through 4,290 (of 8,761 total)
Luis Cazares (11/12/2015)
Eirikur Eiriksson (11/12/2015)
MUST Resist...temptation...bad...joke!!😎
I'm not sure about the bad joke, but I couldn't resist posting. :pinch:
Think English sarcasm mixed with Icelandic frigid humor:-D
😎
Must resist.......
SELECT STUFF(I.T,1,5,'UP') FROM my... AS...
November 12, 2015 at 12:11 pm
November 12, 2015 at 11:34 am
Steve Jones - SSC Editor (11/12/2015)
BTW, if you haven't seen it, I have a fundraiser going for one of the SQL Server communityhttps://voiceofthedba.wordpress.com/2015/11/12/make-a-sqlwish-come-true/
+200
😎
November 12, 2015 at 11:02 am
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907
That's quite good:-D I might be...
November 12, 2015 at 5:07 am
info 58414 (11/12/2015)
I aggregiere data from a table, and should get the max 3 Sales Amount.
If the Customer has only 2 sales, is a DummyRow be issued with value 0;...
November 12, 2015 at 3:53 am
Quick suggestion, look into sparse columns for this one, found it to be one of the more efficient mechanisms for handling this.
😎
November 11, 2015 at 10:00 am
Steve Jones - SSC Editor (11/11/2015)
The biggest data breach?http://www.enterprise-security-today.com/story.xhtml?story_id=99657#
For a day, at least.
😉
This one is going to be worth watching!
😎
November 11, 2015 at 8:53 am
whereisSQL? (11/10/2015)
Ed Wagner (11/10/2015)
crookj (11/10/2015)
Luis Cazares (11/10/2015)
jasona.work (11/10/2015)
DonlSimpson (11/10/2015)
Luis Cazares (11/10/2015)
jasona.work (11/10/2015)
anthony.green (11/10/2015)
crookj (11/10/2015)
djj (11/10/2015)
anthony.green (11/10/2015)
Ed Wagner (11/10/2015)
anthony.green (11/10/2015)
Ed Wagner (11/9/2015)
#MyHeadBobblehead
Dashboard
tableau
Picture
Perfect
Sublime
Submarine
yellow
Blue
NO! Red!
(aaaaahhhhh!)
Python
Spam
Eggs
Shakshuka
November 10, 2015 at 11:14 am
David Rich (11/9/2015)
Type conversion in expression (CONVERT_IMPLICIT(varchar(255),[e].[abc],0)) may affect "CardinalityEstimate" in query plan choice
and this is getting converted to nvarchar(255). Will...
November 9, 2015 at 11:51 pm
mar.ko (11/9/2015)
In other words, I need the temp table to persist along multiple...
November 9, 2015 at 2:36 pm
Echoing Anthony's answer, do not add the service accounts to those groups, it is totally unnecessary! Open the location in Windows Explorer, right click on the folder, choose properties and...
November 9, 2015 at 4:35 am
Brian_Ho (11/8/2015)
What other alternative that you recommend? How can we change this query from MERGE to IF cardnumber EXISTS update ELSE insert method?
The design is flawed and you will...
November 8, 2015 at 1:11 pm
Quick question, can you post the DDL (create table script) for the table(s) used, some sample data as an insert statement and the expected results?
😎
Consider changing the function to a...
November 8, 2015 at 10:56 am
Brian_Ho (11/8/2015)
I cannot use distinct because we want to capture all giftcard transactions...
Then the primary key is wrong as there will be many transactions on the same key, you will...
November 8, 2015 at 10:09 am
Viewing 15 posts - 4,276 through 4,290 (of 8,761 total)