Yes, Chirag... that's precisely what I've been considering. I'm going to look into this option right away as its a lot more convenient. I have a couple of SPs that...

Thanks rbarryyoung 🙂

It should've been:

SELECT DATEDIFF(yy, 'DOB', GETDATE()) -

CASE WHEN DATEPART(m, 'DOB') >= DATEPART(m, GETDATE())

AND DATEPART(d, 'DOB') > DATEPART(d, GETDATE())

THEN 1 WHEN DATEPART(m, 'DOB') >= DATEPART(m, GETDATE())

AND...

Thanks a ton, Jeff... I'm so relieved.

I thought I was gonna have to re-write my import process, which took me ages to write in the first place.. what with all...

Jeff Moden (3/6/2008)

---

Nisha, 2000 rows is nothing. Use Select/Into. Look at my previous post with the test code. Select/Into will load 2000 rows in less than 15...

Ooh.. sorry.. seems like...

Jacob

---

Whoa! Don't do that - SELECT... INTO... on a temp table needs a schema lock to create the temp table and holds it for the duration of the insert. Best...

How do I check the configuration of tempdb? What should I be looking at, Piotr?...

True, I couldn't agree more.

Grant Fritchey (3/5/2008)

---

It depends on what...

Are you looking for something like this?

IF (@TicketID>0)

BEGIN

SELECT * from Tickets

WHERE UserID= '10'

AND TicketID=@TicketID

END

ELSE IF (@TicketID<=0)

BEGIN

SELECT * from Tickets

WHERE UserID= '10'

END

Superb, guys! Thank you soooo much, Matt, Lynn and Gsquared!!! Now I just need to decide which suits me better! Tough choice!

Matt Miller (3/4/2008)

---

hmm - Not quite seeing it -...

Matt Miller (2/29/2008)

---

For a quick "free" boost in performance - since there logically should be no overlap between the two - replace any of the UNION operations above with a...

I tried these earlier, people...

Problem is, the result set of this query is to be returned to the hand held device through an SP. And using the UNION operator in...

Geez!! I feel so foolish! Thanks ALZDBA, thanks Adam!

The export took me like 5 mins!!!!

See post

http://www.sqlservercentral.com/Forums/Topic462157-146-1.aspx?Update=1

if any one needs to know exactly why I was doing all this 🙂

Thanks...

Ok.. first.. sorry about the time lapse between my first post and this reply.

I guess I hurriedly posted my query and I was very vague.

Let me tell you what's really...