P Jones (1/22/2010)

---

Bet that's the dreaded...

Hmm, this IS a SQL 2008 forum that you posted in.....;-)

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...

Lynn, Jeff, Gail, Gus, Jason, Lutz, Paul, Barry... yep,...

Try this:

declare @files table (ID int IDENTITY, FileName varchar(100))

insert into @files execute xp_cmdshell 'dir c:\ /b'

select * from @files

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....

On my SQL2008 (Developer Edition, x64), the modeldev.mdf is 2MB and the...

Might I recommend that until you do understand what this code is doing, that you...

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...

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,

...

The only way...

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...

You might want to check out the WinScp automation FAQ at http://winscp.net/eng/docs/faq#scripting_automation.

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...

Tara-1044200 (1/12/2010)

---

great, Lynn's query

worked for me.

For the same real data type how would i update...