WayneS

Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 5,588 total)

RE: Sql query help

Jeff Moden (9/13/2010)
Wayne... (-- won't show up as green on the forum... but (space-- does. 😉
Hey... it works! Thanks Jeff.
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

September 14, 2010 at 5:25 am

#1220570
RE: increment string in vchar column

a.borgeld (9/13/2010)
I need the output in *.csv but i can concatenate the output.
Good idea to, i tried something else with a loop, come back on it today.
Thanks guys.
The fastest way...
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

September 13, 2010 at 11:59 pm

#1220456
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/13/2010)
I shut down the thread. There's no winning that one. I suspect that the last few positive comments were friends, or the same person, putting up...
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

September 13, 2010 at 11:48 pm

#1220454
RE: Are the posted questions getting worse?

FYI, we now need 22.4 posts/day to make 20k by Nov 18.
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

September 13, 2010 at 7:17 pm

#1220399
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/13/2010)
CirquedeSQLeil (9/13/2010)
Stefan Krzywicki (9/13/2010)
WayneS (9/13/2010)
Alvin Ramard (9/13/2010)
I'm staying out of that Bit thread, and I'm not the author of that saying, so feel free to post it if...
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

September 13, 2010 at 7:15 pm

#1220398
RE: Are the posted questions getting worse?

Alvin Ramard (9/13/2010)
I'm staying out of that Bit thread, and I'm not the author of that saying, so feel free to post it if you want.
I tried to stay 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

September 13, 2010 at 6:54 pm

#1220390
RE: SQL SERVER 2000 DataType

(I think I'm going to regret getting drawn into this...)
Lennie,
It's not until these last two posts of yours that you mention that this field is set to NOT NULL.
Also......
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

September 13, 2010 at 6:49 pm

#1220388
RE: increment string in vchar column

@scott - excellent point (wish I had made 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

September 13, 2010 at 6:37 pm

#1220387
RE: Problems using OpenDataSource on production server to export to Excel

Jack Corbett (9/13/2010)
So if you only do the select you are still getting the Excel error? I assume that you are using an Execute SQL Task, right?
Yes, doing 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

September 13, 2010 at 10:06 am

#1220171
RE: Index creation after of before populate?

If you are inserting a large amount of data, you will probably find it faster to add the index afterwards.
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

September 13, 2010 at 9:14 am

#1220129
RE: Problems using OpenDataSource on production server to export to Excel

Brandie,
Thanks for the tip.
I don't think this is the issue. If I open up a query window in SSMS and directly enter :
select * from OpenRowSet (...)
I get 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

September 13, 2010 at 9:11 am

#1220125
RE: increment string in vchar column

a.borgeld (9/13/2010)
Thanks guys, i'm gonna test a bit for the best solution.
... which is always a good idea for any code you get off the internet.
Please respond back and let...
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

September 13, 2010 at 8:12 am

#1220063
RE: Are the posted questions getting worse?

Threadizens,
I posted Friday about an issue in getting OpenDataSource to work on a server. I can't figure out why I'm getting this issue, and would really appreciate any input you'll...
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

September 13, 2010 at 7:42 am

#1220046
RE: Problems using OpenDataSource on production server to export to Excel

AlexSQLForums (9/10/2010)
Does your ssis service account have permissions to "\\My UNC PATH (with IP Address)\MySpreadsheet.XLS"?
Yes. It first makes the directory (if not already there), deletes the spreadsheet (if already present),...
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

September 13, 2010 at 7:38 am

#1220043
RE: increment string in vchar column

This should work for you:
declare @test-2 table (Staff_nbr varchar(20));
insert into @test-2
select 'Unknown_200'
-- un-remark the following line to work with 4 digit numbers
--UNION ALL select 'Unknown_2000'
;with CTE (staff_nbr) AS
(
select convert(int,...
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

September 13, 2010 at 7:29 am

#1220032

Viewing 15 posts - 3,241 through 3,255 (of 5,588 total)