OMG!

Thats ill. Ill, yet effective. Am still trying to get my head round how it works but somehow it does.

Nice one.

Thanks,

union will distinct records. If one part of your union returns different values you will get extra row(s). Are you trying to group accoss the whole record set? In which...

ah super thats what i was looking for. I did try using stuff but assumed the second int param had to be the length of the string to be inserted.

yep thanks had that way of doing it. But wondered if there was a way you could insert rather than spilt and tag. Wanted to add a parameter on every...

Thanks that works great.

Thanks very much, glad to hear that using views works fine. And i see your point about the inner join.

A good essay by Ralph Kimball i found

http://www.dbmsmag.com/9708d05.html

explains...

Hehe. Yes Max thats right.

This is most concerning as i often take my laptop out of work. I think star bucks should employ guards, armed if necessary, as they have a duty to...

http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=10071

I posted the same problem on this forumn and made more progresss. I have defragged non clustered index on system tables. See what you think and let me know..

Jules

Not sure why you are using variables these can only hold one value hence will only insert one row.

INSERT INTO [Tidemark].[dbo].[logged_in_users]

( [Login_Name],

[DBName],

[LoginTime],

[Lastbatch])

SELECT  master.dbo.sysprocesses.loginame, 

 master.dbo.sysdatabases.name,

master.dbo.sysprocesses.login_time, 

...

but surely there is a possibilty that a script they create will be dependent on the settings they have on their dev db. If they (the developers) have different settings then...

the set operations are not part of the sp itself and only really ensure that the settings underwhich the sp was create are still in place. Sounds to me like...

Thanks for your help.

Have spent some time looking at red gate and it looks like it does the job nicely so going with that one.

Jules

can i ask why you want to do this?

Jules

can you post the code. I think its probably due to recompilation.

have a look here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_queryrecompilation.asp and see if your code contains the elements identified as causes of recompilation.