Viewing 15 posts - 51,631 through 51,645 (of 59,072 total)
Lynn Pettis (3/18/2008)
SELECT
*
FROM
dbo.tblData
WHERE
MonthID between ((3 * @Quarter) - 2) and (3 * @Quarter)
If MonthID is indexed, you still...
March 18, 2008 at 8:10 pm
For your next post... read the article at the URL in my signature line.
March 18, 2008 at 8:07 pm
How many of those "unique identifiers" and sections of names do you have in a file and are they all the same (not the names, the over all structure you...
March 18, 2008 at 8:04 pm
I keep hoping that students will try harder than most of the current set of dummies that couldn't hit the floor with their hat and don't care if they can...
March 18, 2008 at 7:57 pm
If 'FirstName LastName' is in a single column, then...
SELECT REPLACE(namecolumn,' ','')
March 18, 2008 at 7:12 pm
antonio.collins (3/18/2008)
if you open a word, excel, or even a text file and then click file>save, the file will...
March 18, 2008 at 7:08 pm
In my table there for a single accountid there may be max of 72 account_serviceno(ie. most of the cases have upto 6 only) and out of these cases some...
March 18, 2008 at 7:01 pm
Hi, Jeff...it's good to hear from you again ;=)
Good to "see" you again, too. You should come around more often... 😉
Ok... this should do it... this will work in...
March 18, 2008 at 6:45 pm
Please see the following article... explains how to do it and how NOT to do it...
March 18, 2008 at 5:31 pm
I take it you're talking about the following code?
SELECT TOP 10000 --<<<LOOK! CHANGE THIS NUMBER TO CHANGE THE NUMBER OF ROWS!
RowNum...
March 18, 2008 at 4:59 pm
Lynn Pettis (3/18/2008)
March 18, 2008 at 4:32 pm
Lynn beat me to it... 🙂
March 18, 2008 at 4:30 pm
You're welcome... but the IMAGE datatype is 2 GB... the (16) is just a pointer... the following is from BOL 2000...
Image
Variable-length binary data from 0 through 231-1 (2,147,483,647) bytes.
March 18, 2008 at 4:29 pm
If you print your SQL variable, you'll find that your @@FortnightEndDate variables are returning values that need quotes around them... it's an easy fix...
'and(t.trandate>='''+@@FortnightEndDate-13+'''and t.trandate=''' + @@FortnightEndDate +''')'
March 18, 2008 at 4:24 pm
Lynn Pettis (3/17/2008)
March 18, 2008 at 4:16 pm
Viewing 15 posts - 51,631 through 51,645 (of 59,072 total)