WayneS

Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 5,588 total)

RE: Group by problem

How's this?
-- See how you start off by actually creating a table and then
-- inserting the data into it? Your doing this makes it a lot easier
-- for all...
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

March 23, 2011 at 1:49 pm

#1302696
RE: Migration of Data into table with dependencies

beginner123 (3/23/2011)
I have to migrate data into the table which has dependencies. I want to insert data into parent table by using Insert Into command. If I do that will...
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

March 23, 2011 at 1:37 pm

#1302685
RE: Best way to get SQL Server 05 query results into Excel

How about a parameterized query run in Excel? Make the first couple of rows be for entering the parameters (Start Date, End Date, etc.), then pass to the query 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

March 23, 2011 at 1:34 pm

#1302683
RE: How often do you really need dynamic t-SQL?

belgarion (3/22/2011)
Sorry guys. Left out the OPTION (RECOMPILE) in my haste. Added it in.
Be careful with that - you need to be on SQL 2008 SP1 CU5+ (I think...
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

March 23, 2011 at 8:03 am

#1302470
RE: How often do you really need dynamic t-SQL?

... and opc.three beat me to it again... - even posted the same blog link!
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

March 22, 2011 at 4:40 pm

#1302218
RE: How often do you really need dynamic t-SQL?

Your solution is termed a "catch-all query". Read this blog post[/url] by MVP Gail Shaw on why you shouldn't do this... and why the dynamic sql is actually a better...
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

March 22, 2011 at 4:38 pm

#1302217
RE: TRUE & False case Carry

To continue on with what Sean has suggested, I would convert your table like this:
DECLARE @New_Table TABLE (
i_serial INT PRIMARY KEY CLUSTERED,
i_TrueState BIT);
WITH cte...
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

March 22, 2011 at 4:27 pm

#1302214
RE: 'IS NOT NULL' in LEFT OUTER JOIN

Check out this 4-part article[/url] by MVP Gail Shaw. (Read the other parts as well - VERY useful information!)
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

March 22, 2011 at 2:32 pm

#1302179
RE: User per SQL Server level and instance.

google "sp_help_revlogin" - the 2005 version is compatible with 2008.
It will script out the logins and passwords (hashed) where they can be run on another server.
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

March 21, 2011 at 3:39 pm

#1301618
RE: 10 rows to check the high value and do some calcs

Best_boy26 (3/20/2011)
Do you know any easy way to get the data for this from exisiting table and exisitng data to post as a sample... ? I mean from SQL Studio...
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

March 21, 2011 at 2:21 pm

#1301576
RE: Cannot enter sa password during installation

Set it up with windows authentication only, and set yourself as an administrator. After the install, go back and set the sa pwd (unchecking the boxes for checking strength, etc.),...
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

March 21, 2011 at 2:19 pm

#1301573
RE: select column1 of table1 that doesnot contain in column1 of table 2

You can also utilize a "NOT IN" in the where clause.
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

March 21, 2011 at 2:03 pm

#1301561
RE: Are the posted questions getting worse?

SQLkiwi (3/21/2011)
Roy Ernest (3/21/2011)
Hey All, Is there somebody from Boston here?
No, but I'll be in Boston for SQL Saturday #71 :w00t:
crud... shouldn't have canceled going after not getting accepted 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

March 21, 2011 at 1:17 pm

#1301518
RE: Row to Column - Phone Numbers

See the two articles referenced in my signature dealing with Cross-Tabs and Pivots - Parts 1 and 2.
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

March 21, 2011 at 10:05 am

#1301389
RE: Are the posted questions getting worse?

I'm writing a QotD dealing with actions NOT logged - so:
1. Does anyone have some good things that people think are not logged, but actually are (table variables, truncate table...
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

March 21, 2011 at 8:44 am

#1301340

Viewing 15 posts - 1,651 through 1,665 (of 5,588 total)