WayneS

Forum Replies Created

Viewing 15 posts - 5,056 through 5,070 (of 5,588 total)

RE: Are the posted questions getting worse?

GSquared (7/6/2009)
... Heck, I once licked a live electrical cord to see what it would feel like.)
Now that explains a few things.:w00t:
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, 2009 at 6:24 pm

#1020788
RE: SQL Split query

Lynn Pettis (7/6/2009)
Mario Garcia (7/6/2009)
I have used a function to parse data. It can be altered some to fit your needs.
You may want to search this site a bit....
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, 2009 at 8:12 am

#1020406
RE: Do newbies google ?

Lowell... very good insight there. I had not considered this... I just assumed that they ran 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 6, 2009 at 7:57 am

#1020389
RE: dynamic sql in 2005

Ghanta (7/5/2009)
Guys I made the variable @nsql nvarchar(max) to be used for dynamic sql. When I execute using sp_executesql, it throws me error and seems like the sql that 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 5, 2009 at 10:38 pm

#1020199
RE: dynamic sql more then nvarchar(max) more then the max length

edl0022 (7/5/2009)
I have a stored procedure with a variable with type nvarchar(max) to store the sql for executei(exec sp_executesql).... but i found my sql statement is too long(over the size...
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, 2009 at 10:30 pm

#1020198
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

The business case helps tremendously. Let's see what we can come up with...
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, 2009 at 9:59 pm

#1020192
RE: Flakey behavior of code windows on SSC

@Lutz: Thanks for the additional links.
What brought this to a head for me was that I was contacted by three senior posters (senior, by my definition, being > 1000 points)...
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, 2009 at 9:33 pm

#1020187
RE: Add column at ordinal position programmatically

Lowell (7/5/2009)
I slapped together a stored proc sp_GetDDL that returns the table DDL, complete with indexes ,defaults, everything...there's a function version as well; that would probably work just fine 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, 2009 at 8:48 pm

#1020176
RE: SQL Split query

kkknawal (7/5/2009)
Thanks for the solution.
Appreciate it.
Glad we could help 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

July 5, 2009 at 8:45 pm

#1020174
RE: Composite primary key & auto increment problem

paulneyman (7/5/2009)
Ok, can you write a sample how to do that?
No... we're not here to do your work for you. We will, however, guide you to find the solution.
As several...
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, 2009 at 1:28 pm

#1020108
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

wesigler (7/5/2009)
Sorry about the lack of detail, I was trying to keep it simple, but I can see how it was not enough information.
I am trying to create a stored...
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, 2009 at 11:53 am

#1020094
RE: SQL Split query

Jeff Moden (7/5/2009)
I've been bitching to Steve Jones and the others that the code windows don't work correctly with IE. One voice isn't very effective though. It would...
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, 2009 at 11:38 am

#1020090
RE: How to store output of a Script in a .csv file in sql 2005?

rahul.soni2 (7/5/2009)
Hi All, I have a script that generates Server job details on execution.
I need to store the data in .csv file.
I need to send the Output file in 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, 2009 at 9:38 am

#1020066
RE: SQL Split query

lmu92 (7/5/2009)
Peso (7/5/2009)
In your CTE, ROW and VALUE elements are upper case, and in your cross apply the row and value path are lower case.
This results in an empty result....
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, 2009 at 9:35 am

#1020065
RE: Composite primary key & auto increment problem

paulneyman (7/5/2009)Is it posible? 🙂
Not with an identity column. If you really need this, you may need to do it in a trigger.
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, 2009 at 9:26 am

#1020063

Viewing 15 posts - 5,056 through 5,070 (of 5,588 total)