Heh... my very first question is "How do you get the current date and time using a query". Believe it or not, about 1/4 of the candidates that apply...

Heh... nice job there "Joel" 😛

Why can't you just create a linked server to that server and query the Master database on it for all the database names? That way you don't have to...

Karthik... all of the columns in your file are comma...

Shouldn't be a problem... I import 4 million CDR's at a time...

You haven't given us much to work on... What are you using to do the import? And, would...

The only time WAIT FOR blocks anything is when it's inside a transaction (it doesn't block, it causes the blocks to stay open longer). Of course, it keeps a...

Meghna,

Just curious... why do you need to do such a thing?

Heh... I don't think anything is guaranteed across versions, ST... but the same number is returned in both SQL Server 2000 and 2005 when I run your sample code of...

select...

Thanks... I've not experienced that in 2k... mostly because I won't let my guys use WHERE IN... Haven't seen a bad plan for WHERE NOT IN yet, either, but that's...

:hehe: How'z 'bout taday 😛

http://extras.sqlservercentral.com/prettifier/prettifier.aspx

Matt Miller (4/8/2008)

---

Crud... SQL Server is getting more like Oracle every day 😛

Bob...

Don't need the join at all if only the Attendance table is involved and the join has nothing to do with getting rid of the Temp table. Were inserting...

Wow... lemme say that again... WOW! SQL Server 2005 sucks for this! Yeah... it was a real world example.... In the real world, we have SQL Server...

Matt Miller (4/8/2008)

---

Jeff - which ones? sys.all_objects is context-sensitive, as is all_columns, all_views, syscomments, sysobjects. I haven't tested them all - but I have yet to find one...

If you're going to do it that way, Bob, you need to understand that you may have a fundamental flaw in your code... remember the comment in one of your...