WayneS

Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 5,588 total)

RE: Count Summary

MissyDaisy (8/27/2010)
As for the way I ask questions, I was once kindly and gently trained by this forum to format their content to facilitate the possibility of quickly getting an...
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

August 27, 2010 at 7:57 am

#1212958
RE: How to Pivot using T-SQL

take out this line of code...
Order By Substring(CONVERT(varchar(19),RegisterTimestamp,120),1,7) ,Sorce
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

August 27, 2010 at 7:54 am

#1212956
RE: SSIS/DTS Data loss due to implicit casting(?)

Just one point of clarification: the issue isn't with DTS/SSIS. It's with the Jet driver, used to access Excel spreadsheets by those programs. The same problem will show up when...
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

August 27, 2010 at 7:52 am

#1212951
RE: Excel Colum Formatting

Using OpenRowset/OpenDatasource, it can't be done.
However, you can accomplish the formatting by:
1. Use the Export wizard.
2. Use a SSIS package.
3. Use the sp_OA procedures to perform OLE Automation. This article...
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

August 27, 2010 at 7:48 am

#1212945
RE: SSIS Excel

This is getting into the realm where I'd have to start using Google/Bing to find the answer... so I'll leave that exercise to you. I know I've seen 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

August 27, 2010 at 7:45 am

#1212942
RE: parameters = NULL

I think we can get around the parameter sniffing and make this work properly.
First, change this code:
Set @Today = GETDATE();
set @Today = @Today - 1
Set @Year = (select YR_NUMBER from...
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

August 27, 2010 at 7:39 am

#1212933
RE: ALTER TABLE ALTER COLUMN question

I think the default needs parenthesis around the value:
DEFAULT (0), not DEFAULT 0
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

August 27, 2010 at 7:30 am

#1212924
RE: ALTER TABLE ALTER COLUMN question

r.vanlaake-1086273 (8/27/2010)
Hi there,
I need a script to change a TINYINT (not null default 0) TO DECIMAL(6,3).
These are my results:
ALTER TABLE systeem ALTER COLUMN aantal_dagen_vooruit_in_te_plannen DECIMAL(6,3) NOT NULL DEFAULT 0
Incorrect syntax...
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

August 27, 2010 at 6:35 am

#1212886
RE: In SQL SERVER 2005 - where is the Reporting tool

Start Menu | All Programs | Microsoft SQL Server 2005 | SQL Server Business Intelligence Development Studio.
Start a new reporting project, and you're 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

August 27, 2010 at 4:57 am

#1212841
RE: SSIS

RiaRay (8/26/2010)
Hello,
I have got 3 tables in one schema. I am selecting a few columns from the 3 tables using join.Apart from that i am hard coding columns and displaying...
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

August 27, 2010 at 3:25 am

#1212813
RE: Missing sequence number

Jeff Moden (8/26/2010)
I'm waiting to hear back from the OP of what he wants to do if a couple of million row were to be returned because I'd like 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

August 27, 2010 at 3:19 am

#1212812
RE: SSIS Excel

Set up a named range in the second excel spreadsheet. Insert into the named range, not the tab (tabs end in $; named ranges don't).
Edit: you can also specify 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

August 26, 2010 at 8:59 pm

#1212697
RE: Select rows based on 5min interval

Sergiy (8/26/2010)
Can you explain this sequence?
18271999 2010-08-03 07:49:00.000
18271988 2010-08-03 07:51:00.000
And what should happen after 08:05:00.000?
Should the next record be after 08:10:00.000?
Or should it be the first record of the next...
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

August 26, 2010 at 8:30 pm

#1212693
RE: SQL2008R2 on Windows2008R2 or 2003R2

Andrew Fowler-367854 (8/26/2010)
Hi,
I currently have a Windows2003 cluster running SQL2005. We are about to do a harware refresh and want to upgrade to SQL2008R2 to take advantage of some new...
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

August 26, 2010 at 7:51 pm

#1212683
RE: Are the posted questions getting worse?

CirquedeSQLeil (8/26/2010)
WayneS (8/26/2010)
CirquedeSQLeil (8/26/2010)
Alvin Ramard (8/26/2010)
CirquedeSQLeil (8/26/2010)
Well, we can see that Wayne has come into some more free time 😉
I wonder which DBCC TimeWarp parameter value(s) he's using.
716 (caffeine)
1892 (morphine)
346...
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

August 26, 2010 at 7:32 pm

#1212681

Viewing 15 posts - 3,556 through 3,570 (of 5,588 total)