WayneS

Forum Replies Created

Viewing 15 posts - 3,841 through 3,855 (of 5,588 total)

RE: Select Count Help

This link is an excellent place to start.
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:00 am

#1189172
RE: How to do - While Loop, Courser, CTE ???

keyun (7/6/2010)
WayneS - It are correct, My sp runs daily but at some point there db goes off line and do not have connection but as soon as connection open...
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 9:47 am

#1189163
RE: Are the posted questions getting worse?

Be still, my heart!
Jeff's now teaching how to write a c.u.r.s.o.r.
:w00t:
(Who would have thought he would be able to even write one??? ;-):-P )
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 5, 2010 at 10:06 am

#1188827
RE: How to do - While Loop, Courser, CTE ???

If I'm reading this correctly, you need a separate file for each day. If so, then it sounds like you need two basic steps:
1. Procedure to generate output file for...
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 5, 2010 at 8:38 am

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

You can't reference a table by a variable. To get around this, you will have to use dynamic sql.
Something like:
declare @SqlCmd nvarchar(max)
set @SqlCmd = 'INSERT INTO #RowCounts(TableName,NumRows)
SELECT ''' + @TBL...
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 5, 2010 at 8:33 am

#1188796
RE: Split string using Tally Table

jts_2003 (7/2/2010)
I think this is an example of why people don't like to use OVER, since it's so hard to work out what might/will be returned!
I'd like to see a...
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 5, 2010 at 8:28 am

#1188794
RE: Are the posted questions getting worse?

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 contemplating making a presentation...
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 5, 2010 at 8:21 am

#1188786
RE: Split string using Tally Table

I have to admit ... I was looking at this and saying "What the heck???"
For all those interested, the latest version of the "DelimitedSplit8k" function can be found here.
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 5, 2010 at 7:54 am

#1188778
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/1/2010)
What did I do?
I'm not renewed now. And perhaps I won't be if PASS gets to weigh in.
Well, it DOES list you in it. Guess you're...
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 2, 2010 at 7:32 am

#1188202
RE: splitting column into three

NEAL-464478 (7/1/2010)
Is it possible to strip out DESTINATION field into three
Yes it is. However, the people that help out here are all un-paid volunteers, so please HELP US HELP...
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 1, 2010 at 5:54 pm

#1187966
RE: deadlock by 2 triggers on same table

KBSK (7/1/2010)
I just ran the 1st insert statement with Actual Execution plan set to on and I was totally surprised to see a error message:
"The query has exceeded the maximum...
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 1, 2010 at 11:19 am

#1187819
RE: CTE - Avoiding the cursor

Brandie Tarvin (7/1/2010)
Looks like I'm stuck with cursors still, but I'm well on my way to a solution.
Why are you still stuck with cursors? What else needs to be done...
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 1, 2010 at 11:02 am

#1187801
RE: XML to Table

I couldn't get it to work with the "encoding" set, so I'll let you tackle that.
The rest of this shows you how to get those results:
declare @xml xml
--encoding="UTF-16"
set @xml...
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 1, 2010 at 10:37 am

#1187785
RE: Using Function in JOIN

I think the idea of a persisted calculated column is a good idea. However, you will still need to use your function for that.
This may be a bit better. 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

July 1, 2010 at 10:25 am

#1187779
RE: Disable All Triggers

David in .AU (6/30/2010)
Only one thing to note, this stored proc is undocumented which means it may disappear suddenly after a service pack or in new versions.
Well, there is one...
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 1, 2010 at 8:40 am

#1187696

Viewing 15 posts - 3,841 through 3,855 (of 5,588 total)