HowardW (9/14/2009)

---

It's difficult to be sure what you're after without posting the create table statements and giving some sample data (I'm sure someone will be along to post a link...

As Lynn mentioned, we only want *sample* data. So if you have a Name (Like the one in...

I think part of your problem is that you're basing the weekno off of getdate, when you aren't using calendar years to represent what the week numbers should be. ...

vishal.gamji (9/13/2009)

---

Looks like one of the routine tasks that a dba\dev would do right? i would create a dynamic sql script based on the metadata tables (system tables) that would...

Bob Hovious (9/12/2009)

---

I don't speak for anyone else at SSC, only myself.

But in my opinion you really should make the effort to cut-and-paste your question here at...

I think he was just advocating testing things yourself and not always taking other people's word for it, not taking a side on this issue in particular. IIRC, 1 and...

Yeah, this script is only supplying the table name, not the fully qualified servername.databasename.schema.tablename.

You can usually get away with not specifying the first 3, unless you're attempting to...

Keep in mind that because the sp uses dynamic SQL, any wildcards you send in with your text string should work as wildcards.

IE. EXEC UGLYSEARCH '1234%5678'

or

EXEC UGLYSEARCH '1234%[0-9][0-9][0-9][0-9]%[0-9][0-9][0-9][0-9]%5678'

etc. etc.

Also, I...

Understood. Sorry if I sounded preachy, just had to check. Best of Luck in your search, unfortunately I have no such script handy.

Some words come to mind.

Cursor. Dynamic SQL. Slow. Why?

You can use the field names from the information_schema view, use it as a cursor and dynamic sql to...

I've read that BOL article several times, maybe one of these times I'll actually remember what it says the next day ;-).

I still don't see anything that would...

You can use the same evaluation method to decide whether or not to increment the variable for your MessageID.

DECLARE @ID INT

SET @ID = 0

Update #tblCompl

SET Explanation = CASE

WHEN CP<=Guide AND...

Paul White (9/11/2009)

---

Garadin (9/11/2009)

---

You appear to be using a table variable to do your running totals. You don't want to do this, because you can't establish a clustered index...

Here's the other thread I mentioned:

http://www.sqlservercentral.com/Forums/Topic785062-338-1.aspx

The datatype thing could be mostly academic. With SQL2005 he could probably get away with just casting everything as varchar(max) and calling it a...

Paul White (9/11/2009)

---

Garadin (9/11/2009)

---

With that in mind though, consider using sql_variant instead of casting everything to varchars. I say consider because I haven't used sql_variant much myself, so I...