note: thread is from 2007; three and a half years since last post.

also exec sp_help [tablename] provides a lot of nice information, when you need one specific table's info.

you are seeing multiple roles on a single user, and thinking only one of the roles is in place i think.

i just tested this script, and my user does not...

i think you also need to test if the date is less than a minimum acceptable value ..in your case what's the minimum acceptable date you are looking at?

...

I'm thinking when he does a load of data, the statistics go out of date, and "it grinds to a halt"? updating statistics right after the large load seems to...

our shop has a relationship with a local schools database programming class, and they intern every once and a while in house for a couple of days; sounds like something...

Howard as an FYI for your testing, when i ran your code on SQL2005 SP2, it consistently did an index seek, but on either of my SQL2008 machines, it opted...

francissvk (3/29/2011)

---

Hi Lowell,

thanks for your reply. I want to go all levels. but ur proc will go still Grand child level. Can u have any other...

could it be this simple?

i didn't see enough details to directly emoulate the error, so as i was trying something to recreate teh issue, i got this;

similar to the behavior...

to update from another table, you have to establish the relationship betweent he two tables...typically it's a column that has a common value betweent eh two tables:

Update T2

Set CallDate =...

show us your query; what part is failing? what specific error are you getting?

are you using CONVERT(DATE,Yourdatetimefield)?

you want to create empty extended properties?

instead of the select i used, you could use sys.tables and sys.columns this to generate the commands:

WITH myCTE AS

(

SELECT

...

also, along the lines of what Gus said about the row_number() function, I would leave the identity key in a table, and create a view, featuring the row_number() function in...

have you put together a spreadsheet that has the description you want to add yet?

you can create a cell calculation in excel to generate the required statements, or do it...

I like srikant maury's a method of searching for the patindex; nice and clean.

If you are sure no dashes or parenthesis are stored in the string,

yet another way is convert...