Viewing 15 posts - 1,906 through 1,920 (of 5,590 total)
Double-posted. Please do not reply here. Instead, please go to this thread.
January 13, 2011 at 11:55 am
If this is the one I'm thinking about, then I use it also. Do you have a table names "SSIS_Errors"? Check that out for the error message being returned for...
January 13, 2011 at 11:51 am
Just after getting in to work today, one of our servers died. Completely. Might be a long night. Luckily, it only has replicated data on it, but still... 🙁
Investigating options.
January 13, 2011 at 8:37 am
Ray K (1/13/2011)
Ray K (1/12/2011)
Hey Threadizens -- I could use some advice on what I hope is a quick and easy question!
Thank you, fellow Threadizens, for coming to my rescue...
January 13, 2011 at 7:45 am
also, check out the cross-tab/pivot table articles (Parts 1 & 2) linked to in my signature.
January 13, 2011 at 7:16 am
Those are typically articles that have already been published, and are on the re-publish list. That future date is when it will be re-published (notice that they mention "first published"...)
January 13, 2011 at 7:15 am
Dave Ballantyne (1/13/2011)
You should be able to join the conditions logically or'ing them by this technique
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
Then execute the whole statement as a whole with...
January 13, 2011 at 7:10 am
Dave Ballantyne (1/13/2011)
krishnaroopa (1/13/2011)
Recently we replaced cursors with while loop
Ahh , you fell for that one , it is a myth that replacing cursors with a while loop is...
January 13, 2011 at 7:08 am
Sounds like a worthwhile endeavor. I assume you would want to point to newer articles with updated information?
What about if the information is still valid for an older version, but...
January 13, 2011 at 7:05 am
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
January 13, 2011 at 6:58 am
How does this work? (see attached code)
January 13, 2011 at 6:53 am
WayneS (1/12/2011)
Mark-101232 (1/12/2011)
Changingvalue('.','varchar(max)'),1,1,'')
to
value('(./text())[1]','varchar(max)'),1,1,'')
appears to give a better query plan
Thanks for the information... I'll have to test this out.
Edit: WOW! What a difference!...
January 12, 2011 at 10:00 pm
SQLSeTTeR (1/12/2011)
The issue is the code needs to be dynamic as it relates to column 2 (values 64, 65 in this example)Thanks for all your help!
What I did isn't...
January 12, 2011 at 7:15 pm
mister.magoo (1/12/2011)
WayneS (1/12/2011)
[64] = MAX(CASE WHEN UnknownColumnName = 64 THEN AnotherUnknownColumnName ELSE NULL END),
[65] =...
January 12, 2011 at 7:12 pm
Tom Bakerman (1/12/2011)
WayneS (1/12/2011)
Tom,Put an Ampersand (&), Less than (<) or Greater than (>) in your data, and see what happens with or without it:
Got it. Thank you....
January 12, 2011 at 6:59 pm
Viewing 15 posts - 1,906 through 1,920 (of 5,590 total)