Viewing 15 posts - 2,656 through 2,670 (of 2,894 total)
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...
June 28, 2010 at 8:40 am
priya__ (6/28/2010)
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...
June 28, 2010 at 8:21 am
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...
June 28, 2010 at 8:15 am
[withdrawn, as too many answers already :-D]
June 28, 2010 at 8:06 am
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...
June 28, 2010 at 6:35 am
I guess no one replying to you due to the lack of details in your question.
Sample of existing script? Error details?
June 28, 2010 at 6:27 am
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...
June 28, 2010 at 5:21 am
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
June 28, 2010 at 3:56 am
Lowell (6/25/2010)
Run everything in these filing cabinets through the shredder...boss said it was ok, and...
June 25, 2010 at 2:20 pm
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...
June 25, 2010 at 12:38 pm
AndrewSQLDBA (6/25/2010)
I would just take it offline and then see if anyone screams. If no one does after about a month, then drop it...
I would just turn off power on...
June 25, 2010 at 10:43 am
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...
June 25, 2010 at 10:26 am
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 -...
June 25, 2010 at 10:18 am
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...
June 25, 2010 at 10:02 am
Tara-1044200 (6/25/2010)
As asid above how do i do a BULK INSERT from table to table very fast, that sounds like a good approach.
SELECT * INTO NewTable FROM OldTable [WHERE ....]
Depending...
June 25, 2010 at 9:19 am
Viewing 15 posts - 2,656 through 2,670 (of 2,894 total)