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

setlan1983 (10/8/2009)

---

Btw, why need put double dot before "Table1"? Why not single dot?...

But if I want archive the following:

1. "SELECT Sum(SalesAmt) AS TotalSales, COUNT(*) AS TotalTrans FROM DB_A.Sales WHERE TransDT...

can you provide the code that you are using to delete from the excel spreadsheet? Then we can help you figure out what's going wrong.

use an Execute SQL Task, and do this:

declare @dos table (LineText varchar(100))

insert into @dos

execute xp_cmdshell 'dir <REPLACE THIS WITH YOUR DIRECTORY> /o-d /b /a-d'

select top 1 * from @dos

depending on...

Hello starunit,

Thanks for finding this little bit of code, and for coming back, finding this post, and posting the reply.

I've enhanced the code... the following code will resend all of...

Mark,

I've been running into that problem also since I got my new laptop w/ Vista. I haven't had time to check out why.

Are you running 64-bit?

The DatePart and DateName functions should handle what you need to do.

Yes. Just remember to initially use the print statement to examine what is actually being generated; then you can just copy that and make sure it works right.

Well, I think I figured it out... I goofed.

Replace all of those "QuoteName(@field_name, char(39))" pieces of code with just @field_name.

Personally, I wouldn't worry about it. The more you use it, the more ingrained it becomes.

Do you memorize all twenty styles for converting dates/times? How about the styles for converting...

I think Charles said it the best here... "Trust, but verify". If you trust the source (like Grant mentioned), then the verify process can be abbreviated. And if you don't...

svenk7 (9/25/2009)

---

Insert into tw_error1

select*, @d_code

from tw_1

where @field_name is NOT NULL

AND ltrim(rtrim(@field_name)) ''

AND ltrim(rtrim(@field_name)) not in ('Y', 'N')

my prob is when I execute this proc it actually does the opposite...

Hey Bob... Jeff has posted about this type of update before. Basically, it's a time bomb waiting...

Jeff - excellent advice. My question is:...

Elliott W (9/23/2009)

---

As far as logical reads of a table variable.. Keep in mind that if they are not too big they will probably reside fully in memory and...