Viewing 15 posts - 11,341 through 11,355 (of 15,381 total)
edstewart (7/17/2012)
July 17, 2012 at 9:53 am
This can be done using a Tally Table.
Thanks to Wayne Sheffield for the concept on doing this.
declare @LongText varchar(255) = 'Rang the client and agreed they would begin to pay...
July 17, 2012 at 9:50 am
dndaughtery (7/17/2012)
July 17, 2012 at 8:58 am
Lowell also has one that he has posted several times. His does a few things different than mine. His is also resource intensive so DO NOT RUN THIS IN PRODUCTION!!!!
CREATE...
July 17, 2012 at 8:27 am
There is no easy or fast way to do this. You are asking to search all columns in all tables. This is horribly slow. I wrote the following proc several...
July 17, 2012 at 8:26 am
Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1330452-1550-1.aspx
July 17, 2012 at 7:41 am
With over 700 points you are well aware of the benefits and reasons we always ask for ddl, sample data and desired output. Read the first link in my signature...
July 17, 2012 at 7:37 am
dndaughtery (7/17/2012)
Is there a way to do it in the declaration?
Not sure what you mean here. Are you asking if you can declare a variable in such a way as...
July 17, 2012 at 7:33 am
Learned something today from a good question, although it was fairly easy to deduce the correct answer. Given the binary nature of computers the max number of columns without...
July 17, 2012 at 7:15 am
L' Eomot Inversé (7/15/2012)
July 16, 2012 at 8:53 am
You started with posting some really useful ddl and sample data. Then unfortunately you lost it. You have a number of tables that have some sort of ID but no...
July 16, 2012 at 8:30 am
So it has been two days since you posted and not a single person has responded. That is because you didn't even really provide a question. Step back and read...
July 16, 2012 at 8:26 am
amritasehdave (7/15/2012)
I am not a DBA, I was asked to tweak...
July 16, 2012 at 7:04 am
Well it is obvious you didn't bother to read that article or you would realize that what you posted is not helpful. The point of ddl and sample data is...
July 13, 2012 at 1:32 pm
Take a look at this article. It explains what to post for performance issues.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D
July 13, 2012 at 1:09 pm
Viewing 15 posts - 11,341 through 11,355 (of 15,381 total)