WayneS

Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 5,588 total)

RE: Are the posted questions getting worse?

WayneS (7/12/2010)
Fellow Threadizens - I'm having problems getting ssis pkgs/maint plans on a second (named) instance on a 2-node cluster running from the standby node. If you can help, please...
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 13, 2010 at 3:20 pm

#1192366
RE: Combining 8 columns into 4 based on rules

SELECT Line1 = CASE WHEN Freeformat IS NULL THEN Flat + ', ' + House + ' ' + Number + ', ' + Street
...
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 12, 2010 at 9:51 pm

#1191777
RE: Assigning some week numbers

LutzM (7/12/2010)
m.dunster (7/12/2010)
Ok, when I use the term 'adapted', what I really mean is change the table names to suit my database. 😀
Through your example for creating the data...I have...
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 12, 2010 at 7:29 pm

#1191769
RE: getting the results of a SQL script into Excel

You might want to check out this link[/url]
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 12, 2010 at 7:11 pm

#1191767
RE: Rows to Columns (The simplest way please)

Please see the Cross-Tabs and Pivots, Part 1 and Part 2 links in my signature.
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 12, 2010 at 6:54 pm

#1191764
RE: Openrowset don't show all columns

Did changing to the SQL Native Client driver help out? As I demonstrated, it seems to work for me.
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 12, 2010 at 9:29 am

#1191539
RE: Pivot Table

1. How do you determine that it's missing, and that it belongs there?
2. You might want to read the article in the first link in my signature. Doing what 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 12, 2010 at 9:27 am

#1191536
RE: Are the posted questions getting worse?

Fellow Threadizens - I'm having problems getting ssis pkgs/maint plans on a second (named) instance on a 2-node cluster running from the standby node. If you can help, please check...
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 12, 2010 at 7:51 am

#1191470
RE: How to find when a linked server was created

When:
select name, modify_date from sys.servers
Who: someone with sysadmin rights; don't know how to tell who did 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 10, 2010 at 12:41 pm

#1191148
RE: CHECK constraint

How about something like:
select top (1) TheFieldImInterestedIn
from TheTableIHaveToPerformMagicWith
order by TheFieldImInterestedIn DESC
Check constraints can utilize a function, so you might need to embed your max-field-comparison-between-two-fields logic in 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

July 10, 2010 at 12:38 pm

#1191147
RE: Need help with cursor

vandana_j79 (7/10/2010)
Thanks for reply
Actually i want first reopen date. For example even if i have four rows with reopen status i want new date as first reopen status date.
Just...
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 10, 2010 at 9:01 am

#1191139
RE: Solution Required for Mentioned Result.

-- See how you start off by actually creating a table
-- and then inserting the data into it? Doing this really
-- makes things a lot easier for all 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 10, 2010 at 8:52 am

#1191137
RE: Openrowset don't show all columns

It looks like if you change your provider to SQL Native Client, that it will work.
I ran this code in a database named "Sandbox", and both queries return the 600...
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 10, 2010 at 7:19 am

#1191133
RE: Are the posted questions getting worse?

Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone has 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 9, 2010 at 9:14 pm

#1191101
RE: Are the posted questions getting worse?

GabyYYZ (7/8/2010)
Hi folks, I posted a question regarding SQL 2008 Auditing and cycling through the audit logs. What I'd like to know, is there a good intro to Auditing...
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 9, 2010 at 9:08 pm

#1191100

Viewing 15 posts - 3,796 through 3,810 (of 5,588 total)