yeah! basically you can do it one of two ways. if you need to store this data then you need to think about how the data gets in the...

so you have three fields that need to be summed in the fourth field?

I think this should work but I have not tested in try to replace the ";" with a char(13) + char(10). Thsi will insert a carriage return and line break.

REPLACE(col1,...

I love baseball and I have thought about commenting on the thread before but I am a cubs fan which shows I know little about good baseball. But I watch...

I would say it depends on where you are getting the information froma nd how it is stored in teh database. are the multiple e-mail adresses stored in teh...

This would produce the output you would be looking for.

declare @temp table (hostname varchar(20),severity_guid varchar(50),[timestamp] datetime)

insert into @temp (hostname,severity_guid,[timestamp]) values(

'HOLSUSAS006','cb2f2b90-2da4-4075-bcaa-dd5d2cefbfd5','7/11/2010 3:27')

insert into @temp (hostname,severity_guid,[timestamp]) values(

'HOLSUSAS004','0168a833-1732-411e-8205-c2f6cd91737d','7/11/2010 5:27')

insert into @temp (hostname,severity_guid,[timestamp]) values(

'HOLSUSAS004','cb2f2b90-2da4-4075-bcaa-dd5d2cefbfd5','7/11/2010...

do you have an issue you have a question about? there are hundreds of possible issues that could happen and maybe a couple hundred possible solutions for each one of...

I would have to answer yes and no. It depends on what was purchased when VMWare was setup. I am not a VMWare guy but we use it...

What if the CTE is the first thing? for example here is more or less what I am doing.

I tried placing a ; after the SET NOCOUNT ON but...

Since my comment about the color question got a few laughs here is an article with questions that just scream "Please lie to me"

Enjoy the silly interview questions

http://www.businessweek.com/careers/content/sep2005/ca20050921_1099_ca009.htm

that is what I ended up doing but I had to chagne the CTE to a table varible.

Is it possible to put a CTE in a stored procedure? I...

Thanks for the replies

I am using the CTE in a join and I have taken care of this for now by dupming the results into a table variable rather than...

now that we have some more information take a look at an article written by Gail shaw on information needed to be able to help with performace problems.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

I would also...

Sorry I still don't understand where your question is?

you can compare the creation date to getdate() directly in the sql statement you can even chage the creation date thhere based...

basically you need to create multiple datasets. So lets use the following example:

Start with the highest level. this will be a parameter that populates from the dateset.

Lets call...