Viewing 15 posts - 4,291 through 4,305 (of 8,761 total)
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
SQLRNNR (11/6/2015)
The datetime is stored as milliseconds right? From some ambiguous epoch right?
Ehemm, cough cough cough!
😎
November 6, 2015 at 10:16 am
WayneS (11/6/2015)
xsevensinzx (11/6/2015)
who in the hell is applying for a senior position and not know GETDATE()?Just 9 out of 10 applicants. Maybe higher.
That is just being spammed with non-applicable...
November 6, 2015 at 10:13 am
Igor Micev (11/6/2015)
Igor Micev (11/6/2015)
DonlSimpson (11/5/2015)
Ed Wagner (11/5/2015)
djj (11/5/2015)
crookj (11/5/2015)
Igor Micev (11/5/2015)
Luis Cazares (11/5/2015)
anthony.green (11/5/2015)
Igor Micev (11/5/2015)
crookj (11/5/2015)
Ed Wagner (11/5/2015)
anthony.green (11/5/2015)
TomThomson (11/4/2015)
DonlSimpson (11/4/2015)
Weakfrail
Old
Experience
Familiarity
Information
Announcement
Billboard
City
of Heroes
Advengers
Hiro Nakumura
Hiroshima
Bomb
End
TRY
November 6, 2015 at 1:31 am
Raghavender (11/6/2015)
I am trying to attach a database. But I am receiving below error:
Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".
I have added...
November 6, 2015 at 1:30 am
jigging.tech (11/5/2015)
Currently, in the new environment I'm working in, there are no stored procedures everything comes in as Ad-Hoc T-SQL with local variables.
I brought up that we...
November 6, 2015 at 12:04 am
Grant Fritchey (11/5/2015)
BWFC (11/5/2015)
I mentioned the Excel BI tools and apparently they don't want use 'spreadsheets'. I'm pretty sure though that's down to a lack of understanding of the...
November 5, 2015 at 10:05 pm
You have to select / expand the toolbox
😎
November 5, 2015 at 9:57 pm
Viewing 15 posts - 4,291 through 4,305 (of 8,761 total)