WayneS

Forum Replies Created

Viewing 15 posts - 4,861 through 4,875 (of 5,588 total)

RE: How add the data by using ParentId and DepartmentId relation

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...
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

January 21, 2010 at 10:25 pm

#1107086
RE: Best Overall Certification Right Now

Lynn Pettis (1/20/2010)
You will find quite few people here that are more than willing to help mentor those who want to learn.
Lynn, Jeff, Gail, Gus, Jason, Lutz, Paul, Barry... yep,...
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

January 21, 2010 at 10:21 pm

#1107084
RE: How to read list of files in folder using T-SQL?

Try this:
declare @files table (ID int IDENTITY, FileName varchar(100))
insert into @files execute xp_cmdshell 'dir c:\ /b'
select * from @files
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

January 21, 2010 at 7:26 pm

#1107054
RE: Are the posted questions getting worse?

I know what you mean Lynn. Out here, all of the custom development is done w/ SQL Server. But there are a couple of applications that use MySQL and SqlAnywhere....
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

January 21, 2010 at 7:22 pm

#1107053
RE: Database Size

stewartc-708166 (1/20/2010)
Beg to differ
when creating a new SQL2008 db, the mdf defaults to 3MB and the ldf to 1MB.
On my SQL2008 (Developer Edition, x64), the modeldev.mdf is 2MB and 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

January 21, 2010 at 5:33 am

#1106615
RE: Exclude all records from a join which have two specific values in one table

tasdavid (1/20/2010)
And whilst I dont fully understand it, it does the job perfectly so I'm happy.
Might I recommend that until you do understand what this code is doing, that 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

January 20, 2010 at 5:50 pm

#1106421
RE: Using SSIS to zip files and email the zipped files

WayneS (1/4/2010)
clive-421796 (1/1/2010)
How can I automate this so that I dont have to edit the Script Task every day and specify the date of previous days files to include, 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

January 20, 2010 at 5:22 pm

#1106416
RE: Remove Trailing Zeros from Numeric(19,8) datatype

How about?
SELECT h.storenum, h.applydate, h.vouchernum, d.itemnum,
ISNULL(d.qty * CASE WHEN ISNULL(d.baseunitsperpurunit,0) <> 0 THEN d.baseunitsperpurunit ELSE 1 END, 0) qty,
...
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

January 19, 2010 at 10:16 am

#1105551
RE: Remove Trailing Zeros from Numeric(19,8) datatype

matt-996958 (1/19/2010)
Ahhh, I see. I just got the error on a select by itself. Thanks, I'll look into where else the issue could be coming from.
The only 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

January 19, 2010 at 8:55 am

#1105485
RE: Remove Trailing Zeros from Numeric(19,8) datatype

I can't duplicate your problem. Can you provide table structures (DDL) and insert statements (DML) that illustrates the problem? (See the first link in my signature for how to do...
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

January 19, 2010 at 8:42 am

#1105473
RE: SSIS using SFTP (WinSCP) - issue with service account

You might want to check out the WinScp automation FAQ at http://winscp.net/eng/docs/faq#scripting_automation.
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

January 18, 2010 at 3:48 pm

#1105169
RE: Will not write out the rest of my query

SQL Girl,
I have three thoughts on this:
1. Despite repeated requests, you have yet to provide any DDL / DML (CREATE TABLE / INSERT) statements to demonstrate this problem. This 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

January 12, 2010 at 7:51 pm

#1102854
RE: update qry

Tara-1044200 (1/12/2010)
great, Lynn's query
update dbo.TheTable set
TheColumn = 2009 + (TheColumn / 100.00)
worked for me.
For the same real data type how would i update...
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

January 12, 2010 at 1:48 pm

#1102733
RE: update qry

lmu92 (1/12/2010)
WayneS (1/12/2010)
..
The data was enclosed in quotation marks, so it was assumed that this was a string.
...
I agree with you and my comment didn't question your solution at all...
Since...
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

January 12, 2010 at 1:44 pm

#1102729
RE: update qry

lmu92 (1/12/2010)
I actually doubt you've tried the solution Wayne proposed....
He suggested to add a string to a string.
ORIGINAL QUESTION
How do i update a table with prefix number for the existing...
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

January 12, 2010 at 12:50 pm

#1102681

Viewing 15 posts - 4,861 through 4,875 (of 5,588 total)