Lynn Pettis (3/18/2008)

---

Or

SELECT

*

FROM

dbo.tblData

WHERE

MonthID between ((3 * @Quarter) - 2) and (3 * @Quarter)

If MonthID is indexed, you still...

For your next post... read the article at the URL in my signature line.

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...

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...

If 'FirstName LastName' is in a single column, then...

SELECT REPLACE(namecolumn,' ','')

antonio.collins (3/18/2008)

---

i think you're making a mountain out of a molehill.

if you open a word, excel, or even a text file and then click file>save, the file will...

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...

Good to "see" you again, too. You should come around more often... 😉

Ok... this should do it... this will work in...

Please see the following article... explains how to do it and how NOT to do it...

http://www.sqlservercentral.com/articles/Test+Data/61572/

I take it you're talking about the following code?

SELECT TOP 10000 --<<<LOOK! CHANGE THIS NUMBER TO CHANGE THE NUMBER OF ROWS!

RowNum...

Lynn Pettis (3/18/2008)

---

The image data type is a BLOB type. It stores a 16 byte pointer in the data record that points to the first data page that holds...

Lynn beat me to it... 🙂

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 2³¹-1 (2,147,483,647) bytes.

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 +''')'

Lynn Pettis (3/17/2008)

---

I have looked at the two files with CREATE Table statements, and I'm not going to do anything with those as it is too hard to see what's...