Viewing 15 posts - 4,861 through 4,875 (of 5,588 total)
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
January 21, 2010 at 10:25 pm
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
January 21, 2010 at 10:21 pm
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
January 21, 2010 at 7:26 pm
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
January 21, 2010 at 7:22 pm
stewartc-708166 (1/20/2010)
Beg to differwhen 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
January 21, 2010 at 5:33 am
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
January 20, 2010 at 5:50 pm
WayneS (1/4/2010)
clive-421796 (1/1/2010)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 20, 2010 at 5:22 pm
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
January 19, 2010 at 10:16 am
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
January 19, 2010 at 8:55 am
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
January 19, 2010 at 8:42 am
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
January 18, 2010 at 3:48 pm
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
January 12, 2010 at 7:51 pm
Tara-1044200 (1/12/2010)
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
January 12, 2010 at 1:48 pm
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
January 12, 2010 at 1:44 pm
lmu92 (1/12/2010)
I actually doubt you've tried the solution Wayne proposed....He suggested to add a string to a string.
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
January 12, 2010 at 12:50 pm
Viewing 15 posts - 4,861 through 4,875 (of 5,588 total)