Viewing 15 posts - 4,276 through 4,290 (of 8,753 total)
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
Quick question, would there be duplicate CardNumber in the dbo.GiftCard table?
😎
Slight alteration to the query
MERGE [dbo].[GiftCard] as target
USING
(SELECT DISTINCT
g.[CardNumber]
,YEAR(g.[Date])
...
November 8, 2015 at 9:56 am
Can you post the DDL (create table script) for both tables?
😎
November 8, 2015 at 9:09 am
Lynn Pettis (11/6/2015)
November 7, 2015 at 6:07 am
Lynn Pettis (11/6/2015)
November 7, 2015 at 6:07 am
Grant Fritchey (11/7/2015)
xsevensinzx (11/6/2015)
Least it has the database engines listed. :hehe:Get's even worse with the use of 'NoSQL' or 'Hadoop'.
Yeah, but it shows Profiler
BURN IT WITH FIRE!
Grant, how about an...
November 7, 2015 at 6:02 am
giri10488 (11/7/2015)
A log file size of a production database has been increase from 4gb to 150 gb initial size.Now i want to find when it...
November 7, 2015 at 5:18 am
Luis Cazares (11/6/2015)
Sean Lange (11/6/2015)
Ed Wagner (11/6/2015)
Brandie Tarvin (11/6/2015)
Greg Edwards-268690 (11/6/2015)
Eirikur Eiriksson (11/6/2015)
Three options given
1) To...
November 6, 2015 at 12:33 pm
On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?
Three options given
1) To get the current time (wrong)
2) You don't (correct)
3) Time for the applicant...
November 6, 2015 at 10:21 am
Viewing 15 posts - 4,276 through 4,290 (of 8,753 total)