Forum Replies Created

Viewing 15 posts - 46,126 through 46,140 (of 59,062 total)

  • RE: Cursors Be Gone!

    jacroberts (1/2/2009)

    The stored procedure that calls the function just takes the results table from the TVF and inserts this into a reporting table number of new site visits for every...

    January 3, 2009 at 9:18 am

    #920695

  • RE: Cursors Be Gone!

    Matt Whitfield (1/2/2009)

    Temp table version of the above, outside the scope of a function

    Exec time 3.843

    Oh, now I know I need to upgrade my poor ol' 6 year old work...

    January 2, 2009 at 7:01 pm

    #920621

  • RE: How to add columns dynamically in a table????

    talk2riya15 (1/1/2009)

    Hi Everybody,

    Can you please tell me how to add columns dynamically in a table...like i have created one employee table with EmployeeId, Name Passpost No,Permanent addresss....i want to add...

    January 2, 2009 at 5:49 pm

    #920616

  • RE: Ok, its their first day on the job.

    Stephanie J Brown (1/1/2009)

    But I love books...

    I'm with you there... I never throw one away, either. I've got some old DOS 2.0 books with a trick in them here...

    January 2, 2009 at 5:41 pm

    #920614

  • RE: Help creating a SQL query

    santosh.shrestha (1/1/2009)

    Sorry about my ignorance.

    The solution query is as follow:

    SELECT Item, Name, COUNT(Amt), MIN (Amt), MAX(Amt), MIN (Date), MAX (Date) FROM Table1 GROUP BY Name, Item

    Thanks again.

    Cool... Thanks, Santosh. ...

    January 2, 2009 at 5:38 pm

    #920613

  • RE: Help with datetime sql

    Chris Morris (1/2/2009)

    It's always nice to have some proof...and here it is...

    Very, [font="Arial Black"]very [/font]well done... there's absolutely no argument when the arguments offered are in the form of viable,...

    January 2, 2009 at 5:28 pm

    #920612

  • RE: Problem loading a file FTPed from Mainframes into SQL Server table using SSIS

    If there's nothing in the file that violates either privacy or policy, my recommendation would be to attach the file to a post and let us take a crack at...

    January 2, 2009 at 5:10 pm

    #920610

  • RE: Table variable as Output Parameter

    aziz.kapadia (12/31/2008)

    Can I declare table variable as output parameter in stored procedure?

    Probably of more importance, what is it that you're trying to do? You'll be amazed at the possible...

    January 2, 2009 at 5:06 pm

    #920609

  • RE: Table variable as Output Parameter

    Grant Fritchey (12/31/2008)

    Thanks for the correction. I wasn't sure and I haven't really looked at the table valued parameters yet. I should have kept my mouth shut.

    Heh... nope... then I...

    January 2, 2009 at 5:04 pm

    #920608

  • RE: The Year in Review 2008

    So! You carry the cell phone to the barn... when ya goin' for the implant, pal? ;):D:hehe:

    January 2, 2009 at 4:08 pm

    #920598

  • RE: How to Short-circuit Where Clauses

    Good golly... I'm glad I'm not the only one that believes in the usage of well formed and safe dynamic SQL. 🙂

    January 2, 2009 at 3:56 pm

    #920596

  • RE: Join Query (Please Urgent !!!!!!!!!!)

    NULL (1/2/2009)

    DECLARE @Tour TABLE (tourID INT IDENTITY PRIMARY KEY

    ,tourName VARCHAR(50)...

    January 2, 2009 at 3:35 pm

    #920591

  • RE: Corporate Software Development

    DBAdmin (1/2/2009)

    Again, my original post was not intended to say that IM has no legitimate uses. Instead, I was commenting on two things in combination, one of them being IM...

    January 2, 2009 at 3:29 pm

    #920587

  • RE: Can you solve this sort problem?

    RBarryYoung (1/1/2009)

    Heh. Gail is much faster than me... 🙂

    Heh... while that may be true, your patience and depth of explanation are noteworthy. I'd have killed and eaten...

    January 2, 2009 at 3:25 pm

    #920585

  • RE: identity column

    I've really got to respectfully disagree... the use of a "sequence" table of any kind will become a major hotspot, a possible source of a huge number of deadlocks, and...

    January 2, 2009 at 3:19 pm

    #920580

Viewing 15 posts - 46,126 through 46,140 (of 59,062 total)