WayneS

Forum Replies Created

Viewing 15 posts - 1,936 through 1,950 (of 5,588 total)

RE: Creating a comma-separated list (SQL Spackle)

Rex - yes, that way will work. However, please see this article[/url] for performance differences between the two methods. String manipulation has never been a strong area for MS, 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

January 12, 2011 at 8:14 am

#1272397
RE: Log File VLFs

Scott Arendt (1/12/2011)
That was a good question and I learned a couple of things from it.
I thought that 4 VLFs would be created and almost answered that way until 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

January 12, 2011 at 6:56 am

#1272341
RE: create table with a subset of columns from another table

All of these solutions would require you to write dynamic sql to create that third table, and it doesn't help with the data types.
This isn't the type of thing that...
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

January 12, 2011 at 6:53 am

#1272340
RE: Creating a comma-separated list (SQL Spackle)

glock 71629 (1/12/2011)
This is exactly the situation where I use PowerShell frequently. I am able to export data from whatever complex query. Idea is something like this:
Invoke-Sqlcmd -ServerInstance myServer -Database...
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

January 12, 2011 at 6:42 am

#1272335
RE: how to concatinate of Column in a Single row.

You've got good timing. An article[/url] was just published today that covers this for you.
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

January 12, 2011 at 4:50 am

#1272285
RE: finding out instance name using reg query

SELECT ServerName = @@servername,
InstanceName = CASE WHEN CharIndex('\', @@ServerName) = 0 THEN NULL
...
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

January 12, 2011 at 4:48 am

#1272284
RE: Are the posted questions getting worse?

Does anyone know how to directly read an XML file from an internet address in T-SQL? Please respond here... and think about writing a SQL Spackle article on it!
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

January 12, 2011 at 4:24 am

#1272277
RE: STUFF concatenation

Hello Nick,
What timing! An article[/url] was just published today that shows how to do this very thing. Check it out!
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

January 12, 2011 at 4:02 am

#1272270
RE: Creating a comma-separated list (SQL Spackle)

reto.eggenberger (1/12/2011)
Thank you for this tip with the STUFF function.
Is the order by in the subquery really needed? I think the for xml does it anyways. If you don't use...
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

January 12, 2011 at 3:56 am

#1272268
RE: Using variables in 'Execute SQL Task'

This BOL entry should answer your questions.
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

January 11, 2011 at 3:12 pm

#1272116
RE: splitting the records

Does this work for you?
DECLARE @Tbl TABLE (
id INT,
StartTime DATETIME,
NoOfHours VARCHAR(5),
FinishingTime DATETIME
)
INSERT INTO @Tbl
SELECT 19,'01/11/2011 12:30:00 ','02:30',''
UNION ALL
SELECT 18,'01/11/2011 16:40:00...
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

January 11, 2011 at 2:46 pm

#1272107
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/11/2011)
Thanks, but I'm actually somewhat hoping I lose. I think the travel might kill me in May if I get the Rally.
Now you tell us......
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

January 11, 2011 at 10:31 am

#1271976
RE: Loading XML Data into SQL Server (SQL Spackle)

Amy.G (1/11/2011)
Steve,
Do you mean I need to go into the file and type in [CDATA[... where all HTML appears?
Amy
Well, run this little test:
declare @xml1 XML, @xml2 XML;
set @xml1 =...
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

January 11, 2011 at 10:28 am

#1271972
RE: Loading XML Data into SQL Server (SQL Spackle)

weharrelson (1/11/2011)
Sorry for the delay guys:
DECLARE @x XML
SELECT @x= CONVERT(xml, BulkColumn, 2) FROM
OPENROWSET(BULK 'C:\data.xml', SINGLE_BLOB) AS x
Ahh, I see. You loading the file in as I showed 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

January 11, 2011 at 10:18 am

#1271964
RE: Memory tables versus physical tables

Jorge,
Might I suggest two things:
1. First, do not add things to master. Instead, create a database (named something like "Common"), and put all your special stuff there. Yes, you can'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

January 11, 2011 at 9:37 am

#1271948

Viewing 15 posts - 1,936 through 1,950 (of 5,588 total)