Viewing 15 posts - 9,541 through 9,555 (of 26,489 total)
CptCrusty1 (9/14/2012)
Snape's hair wasn't as cool... LOLThink Star Wars, meets Star Trek... Add in Spock, and a little bit of Space Balls.
I know the movie, Galaxy Quest....
September 14, 2012 at 11:02 am
KumarSQLDBA (9/14/2012)
cast (Processing_Date as date).
But it giving error like 'Msg 241, Level...
September 14, 2012 at 10:59 am
ianderson 63159 (9/14/2012)
I...
September 14, 2012 at 10:54 am
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?My first reaction was, "LOL!". Posted a more serious comment.
Remembering that this discussion had occurred before, but not...
September 14, 2012 at 10:50 am
CptCrusty1 (9/14/2012)
I Just LOVE GSquared's Avatar... it's been so long since that movie was out I bet hardly anyone knows who that is.
Professor Snape (sp?). ...
September 14, 2012 at 10:48 am
SQL Kiwi (9/14/2012)
How's the refusing to be baited by Celko thing going, Lynn?
I had to give in. It hurt too much.
Hey, any comments on what is posted here?
Just curious.
September 14, 2012 at 10:08 am
ScottPletcher (9/14/2012)
Lynn Pettis (9/14/2012)
/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 09/14/2012 09:43:51 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DelimitedSplit8K]') AND type in (N'FN',...
September 14, 2012 at 10:05 am
I think I would go with something more like this:
INSERT INTO t15a_All
SELECT
t.*
FROM
t199815a t
inner join t15_All ta
...
September 14, 2012 at 10:04 am
Where do you think I have been getting my learning?
September 14, 2012 at 9:58 am
CptCrusty1 (9/14/2012)
I'm actually reading it now.... LOLI"m thinking we should take this discussion offline... I can PM you with my personal address...
Be sure to read the discussion...
September 14, 2012 at 9:51 am
Glad I could help.
September 14, 2012 at 9:47 am
/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 09/14/2012 09:43:51 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DelimitedSplit8K]') AND type in (N'FN', N'IF', N'TF', N'FS',...
September 14, 2012 at 9:44 am
CptCrusty1 (9/14/2012)
Lynn,I don't recognize the DelimitedSplit8k function.. I'm assuming this is something custom?
Actually, it's Jeff's (and the communities) function from his Tally Oh article. Hang on, I'll...
September 14, 2012 at 9:43 am
Would you please post the DDL (CREATE TABLE) statements and include the indexes defined.
September 14, 2012 at 9:39 am
How about this:
DECLARE @t TABLE (EMGID Varchar(7), Reference Varchar(8), Backscan Int);
INSERT INTO @t
SELECT '1267202', '32655185', 1
UNION ALL SELECT '1267202', '32655185', 0
UNION ALL SELECT '1239667', '33264522', 1
UNION ALL SELECT '1239667', '33264522',...
September 14, 2012 at 9:30 am
Viewing 15 posts - 9,541 through 9,555 (of 26,489 total)