I want to buy shares in your company or, at least, buy advertising space on your site !!!! 😀

1000 (new) viewers per second during 8 hours working day means 28,800,000...

priya__ (6/28/2010)

---

Thanks for quick response,

I need a case statement and need to count another column based in first column is null or not, I have many cases but this...

If you want to extract the data from the database in a format readable in Excel, use xp_sendmail extended stored proc. It can execute the query, put results into...

[withdrawn, as too many answers already :-D]

Try this:

INSERT INTO PC_Tbl_FooterTemplate_Position

(

TemplateId,

Position,

[Content]

)

SELECT @FooterId, Position, Content

FROM OPENXML (@index, '/NewDataSet/Table1')

WITH (

Templateid bigint 'Templateid',

Position nvarchar(50) 'Position',

Content...

I guess no one replying to you due to the lack of details in your question.

Sample of existing script? Error details?

You better to stay with using TransactionScope :-).

It is not quite clear what are you trying to do in one transaction.

You can submit batch of records into stored proc in...

If your Id's are always increases by 1 and you have no gaps, you can use this:

select t1.ID as Id1, t2.ID as Id2

from @test-2 t1 left join @test-2 t2...

Lowell (6/25/2010)

---

this kind of request ranks up there with a request that was once heard at Enron:

Run everything in these filing cabinets through the shredder...boss said it was ok, and...

Do you have "lightweight pooling" turned off? Make sure it is off.

What sql2008 edition you have?

It is unusuall behavior. The server configuration should not revert back on restart of the...

I would just turn off power on...

You are right for SQL2008 the way to go is to use new DATE datatype to store a date.

(My mistake, I was still in SQL2005 forum mode...)

Interesting enough that the...

Value of @cols variable is NULL. It means that your @query will be NULL also. So, nothing to print!

Changing "PRINT @query" to "SELECT @query" will confirm the above -...

It is known practice to use INT datatype to store dates especially in large datawarehouses... BUT!

Not in the YYYYMMDD format!

As in order to convert it back tp date you will...

SELECT * INTO NewTable FROM OldTable [WHERE ....]

Depending...