Forum Replies Created

Viewing 15 posts - 16,726 through 16,740 (of 26,484 total)

  • RE: How many rows are returned from the query below?

    Fatal Exception Error (3/3/2010)

    bitbucket-25253 (3/3/2010)

    Fatal Exception Error

    I think part of his point is that versions were not specified which is fairly important.

    Disagree. If you are attempting to...

    March 3, 2010 at 7:06 am

    #1127746

  • RE: How many rows are returned from the query below?

    honza.mf (3/3/2010)

    Lynn Pettis (3/3/2010)

    Second, it doesn't matter how many rows are in the table tblUsers (unless it only contained one row, but everyone so far has assumed more than one),...

    March 3, 2010 at 7:03 am

    #1127743

  • RE: How many rows are returned from the query below?

    Toreador (3/3/2010)

    Lynn Pettis (3/3/2010)

    Second, it doesn't matter how many rows are in the table tblUsers (unless it only contained one row, but everyone so far has assumed more than one),...

    March 3, 2010 at 6:54 am

    #1127733

  • RE: TRICKY SQL QUERY

    martin.edward (3/3/2010)

    Dear Experts ,

    I would like to do the following :-

    get the date out of a certain column in a table

    select docdate from tablename

    Check if the docdate is...

    March 3, 2010 at 6:49 am

    #1127729

  • RE: IS SQL SERVER 2005 SUPPORT INCREMENTAL BACKUP

    vbprogrammer1986 (3/3/2010)

    I Want a Backup copy of that portion of data which is change since last any type of backup(full or differential).what is the name of this type backup? may...

    March 3, 2010 at 6:46 am

    #1127726

  • RE: How many rows are returned from the query below?

    I don't agree that the question was poorly written, just poorly read.

    First, it is obvious that this question was directed to SQL Server 2005/2008 because of the CTE. CTE's...

    March 3, 2010 at 6:35 am

    #1127716

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/2/2010)

    Chris Morris-439714 (3/2/2010)

    "How about them Bears?" 🙂

    Is it just me, or are the posters who appear to be the students, the ones who have the nerve to post...

    March 2, 2010 at 1:32 pm

    #1127391

  • RE: Can't figure out why DBCC CHECKDB is running

    mike mcneer (3/2/2010)

    I would setup a profiler trace.. add additional columns such as hostname,ip,login and then the standard stuff and filter the trace to only pickup that domain admin account...

    March 2, 2010 at 12:51 pm

    #1127357

  • RE: Avoid dynamic SQL

    Rob Schripsema (3/2/2010)

    Lynn,

    Wow. Very cool, very clever....but with all of the SUBSTRINGing, CHARINDEXing and concatenating going on, is this really more efficient than a simple while loop? (Oh dear, I...

    March 2, 2010 at 11:42 am

    #1127317

  • RE: Problem in join update

    Julie Breutzmann (3/2/2010)

    The Dixie Flatline (3/1/2010)

    Keith,

    To handle concatenation of nulls, you need use either the ISNULL() or COALESCE() function. .

    I recommend that you use COALESCE. ISNULL is also...

    March 2, 2010 at 11:20 am

    #1127305

  • RE: Avoid dynamic SQL

    Rob Schripsema (3/2/2010)

    I do know that SSRS passes field(parameter?) lists as a string of comma-separated values. That doesn't require dynamic SQL or even a cursor/while loop to split it...

    March 2, 2010 at 11:16 am

    #1127301

  • RE: table scan problem

    Tara-1044200 (3/2/2010)

    Create Table #Daterange

    (

    start_d datetime,

    end_d datetime,

    )

    begin

    Insert into #Daterange

    Values

    ('02/12/2003','12/03/2009')

    end

    select distinct a.empnumber, filldate,empcode

    into #tmp_calc

    from Vwrevenue as a inner join #revdates as b on a.empnumber = b.empnumber, #daterange

    where filldate between start_d and end_d

    Above...

    March 2, 2010 at 10:55 am

    #1127285

  • RE: Tally table and substring error

    Lowell,

    Try this change. I stumbled on to it so I can't explain (at this time) why it makes the in-line code work.

    WHERE N < DATALENGTH(@vbCrLf + @input) -- REMOVED...

    March 2, 2010 at 10:48 am

    #1127280

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (3/2/2010)

    Well this was interesting. Had someone ask for their account to be closed here since the questions haven't been good the last month and the quality...

    March 2, 2010 at 10:37 am

    #1127271

  • RE: Tally table and substring error

    I'm not sure at this time. This is something i will have to try a play with when I have a little more time. Nice SQL Puzzle, I...

    March 2, 2010 at 10:31 am

    #1127266

Viewing 15 posts - 16,726 through 16,740 (of 26,484 total)