how would I use this if I wanted to use the following:

declare @count int

set @count = ?

if @count>=1

Jack Corbett (7/29/2008)

---

You can immediately follow your first query with Select @@ROWCOUNT which...

great, that's really useful to know.

Thanks.

Interesting... do you have any good tutorials that have helped you with this?

GSquared (7/25/2008)

---

I don't think there's a way to customize that.

Personally, I've found attaching the query results pretty useless....

very true 🙂

that was a stupid question. Thanks for your help.

Jason Selburg (6/16/2008)

---

UPDATE...

Thanks. I would like to actually convert these permanently to upper case.

thanks

great! the tab between the ' ' works perfectly.

I had long since given up on this thread. Thanks for the solution.

Adam.

Ted Walsh (5/27/2008)

---

I have had similar problems with...

Ah, I forgot about LEN.

Thanks for all your help.

Thank you.

I don't know too much about variables.

set @zip = (select zipcode from DEMOG) does not work because there is more than one result.

How would I go about updating all...

I have, and the data rows are still squashed...

Jack Corbett (2/29/2008)

---

Because you are naming the file with an "XLS" extension, Excel thinks it is a native file and is not looking for a delimiter.

I would use...

Matt Miller (2/26/2008)

---

Sure - using the "old-style" pivotting syntax:

Select user, datepart(yyyy,datein) as Yr,

sum(case when datepart(mm,datein) =1 then 1 else 0 end)...

Matt Miller (2/25/2008)

---

Select user,

datepart(yyyy,datein)*100+datepart(mm,datein) as yearmonth,

count(datein) as LoginCount

from login

WHERE

...

Yes, count by month by...