Viewing 15 posts - 11,341 through 11,355 (of 15,376 total)
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
Now we can all see the code. However as already stated you need to post ddl, sample data and desired output before anybody has a chance at helping.
Why all the...
July 13, 2012 at 1:01 pm
For those of you too nervous to open a text file...
CREATE Procedure [dbo].
--@evt_keys nvarchar(4000)=null
@last_export nvarchar(20)=null
as
--select @last_export = null
Create table #temp_keys (Id uniqueidentifier)
--if rtrim(isnull(@evt_keys, ''))=''
--insert into #temp_keys select evt_key from...
July 13, 2012 at 12:56 pm
You need to provide ddl, sample data and desired output. Take a look at the first link in my signature for best practices when posting questions.
July 13, 2012 at 12:53 pm
Lynn Pettis (7/13/2012)
kaspencer (7/13/2012)
Once again we are down to the process whereby questions are vetted and approved or disapproved for publication. This must be improved.Kenneth Spencer
Are you volunteering to do...
July 13, 2012 at 12:08 pm
Viewing 15 posts - 11,341 through 11,355 (of 15,376 total)