WayneS

Forum Replies Created

Viewing 15 posts - 3,826 through 3,840 (of 5,588 total)

RE: How to Avoid loop?

Hi Parthi,
This is actually pretty easy to do... once you understand how to do it 😀
First, you need to put the data into something with an XML data type. In...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 8, 2010 at 8:30 am

#1190282
RE: SQL Server 2008 Table Valued Parameters Performance

Excellent article. The only thing I think would have been nice to add (and which has been covered in this discussion forum) is how to pass the data into the...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 8, 2010 at 7:41 am

#1190233
RE: Tabify Select Lines

Duncan Pryde (7/8/2010)
It only "tabifies" groups of 4 spaces starting from the left, so if you have 5 spaces at the beginning of the line, you'll get a tab and...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 8, 2010 at 5:53 am

#1190170
RE: Diffrentiating scalar and table value functions

select name
from sys.objects
where type IN ('IF', -- SQL_INLINE_TABLE_VALUED_FUNCTION
'TF',...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 7, 2010 at 7:47 pm

#1189957
RE: query each table in list of table names

crossmj (7/7/2010)
Wayne,
It took me awhile to understand this message:
Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1
Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.
I finally...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 7, 2010 at 10:46 am

#1189746
RE: Incrementing a column during an UPDATE

I'll bet you didn't know you can update variables at the same time as columns in an UPDATE statement. This should work for you.
declare @clientid int
select @clientid = select max(clientid)+1...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 7, 2010 at 10:33 am

#1189739
RE: How can I improve this? Any suggestions?

mmcardle (7/7/2010)
I was hoping to use a table variable because a) I was a bit temp table-happy when I first started with SQL and realised later that it's best to...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 7, 2010 at 10:23 am

#1189732
RE: Insert Value in Identity Column

SQLEE (7/7/2010)
How do I account for the value of an identity column when doing an insert to a table. A NOT NULL vaule won't work and throws an error. Col4...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 7, 2010 at 10:13 am

#1189727
RE: Are the posted questions getting worse?

Grant Fritchey (7/7/2010)
WayneS (7/6/2010)
Jeff Moden (7/6/2010)
CirquedeSQLeil (7/6/2010)
WayneS (7/5/2010)
Since there's a bit of talk going on about topics to present and such, I'd like to get some input from some of...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 7, 2010 at 5:30 am

#1189532
RE: Are the posted questions getting worse?

Jeff Moden (7/6/2010)
CirquedeSQLeil (7/6/2010)
WayneS (7/5/2010)
Since there's a bit of talk going on about topics to present and such, I'd like to get some input from some of the Threadizens...
I've been...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 6, 2010 at 10:09 pm

#1189405
RE: query each table in list of table names

crossmj (7/6/2010)
Thanks to Wayne and Lowell.
My project is currently on hold, but I have been able by using a modified version of Lowell's script to find the tables containing...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 6, 2010 at 4:05 pm

#1189365
RE: Error after converting int to date data type

I ran the steps you posted, but did not receive an error. It looks like you might be utilizing the GetBytes function when it's generating your error, but you didn't...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 6, 2010 at 12:55 pm

#1189288
RE: How to Minus X amount of minutes in a T-SQL query

Mr_Bacon (7/6/2010)
I think I have cracked it, might be overcomplicating things but the below seems to work, pending further testing. The below covers me for the 24 hour period required.
I...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 6, 2010 at 11:04 am

#1189213
RE: Cursor

HoustonFirefox (7/6/2010)
I personally hate cursors and try not to use them if at all possible. In keeping with our TSQL roots I submit:
DECLARE @Database VARCHAR(255)
DECLARE @DBList TABLE (DBName varchar(255),...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 6, 2010 at 10:15 am

#1189183
RE: Loop, Cursor or both?

george.greiner (6/29/2010)
Okay here is the data and tables you asked for assuming I did this correct.
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#FileInfo','U')...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 6, 2010 at 10:08 am

#1189179

Viewing 15 posts - 3,826 through 3,840 (of 5,588 total)