What picture?

You're welcome.

Erik Kutzler (11/11/2009)

---

Or, instead of creating a table and still using a derived column transformation while assuming the file extension is still 3 characters in length, this will work:

SUBSTRING(@[User::FileName],LEN(@[User::FileName])...

I'd definitely set up a server-side trace. Minimal impact, will get you the data you need, and has a number of other benefits as well.

If the file extension is consistently 3 characters (pretty usual), then something like this would work:

create table #T (

ID int identity primary key,

FName varchar(256),

FDate as left(right(FName, 12), 8));

insert into #T...

Bob Hovious 24601 (11/11/2009)

---

Oh look, a little upside down heart....

... or is that an ace of spades? ....

.... a hooded apparition with glowing eyes?

(DANG, this is a...

I think the way I'd do it would be to join rows based on UserKey, ProductKey and DateKey, with equality tests on those columns, and a join based on the...

If you deny select on the system objects to the accounts that aren't supposed to have intellisense, that should do it. It depends on the ability to select from...

Are you trying to import all the text into a single row in a table?

If so, OpenRowset with Bulk and Single_CLOB options, might be the better way to go on...

That data comes from Management Studio, so far as I know. Not from the database itself. I don't think there is a way to access it. Could...

The error is because of the comma after PRHours.

Matt Miller (#4) (11/10/2009)

---

Michael Valentine Jones (11/10/2009)

---

There may be jobs where knowing the answers to those questions would be important. I have encountered consulting companies that seem more interested...

Hey, I say Enterprise Class servers/software deserve Enterprise Class hammers! That's all! 😀

On a site all about SQL Server, he proposes using Excel instead of Reporting...

Depends on how you define the word "hammer"[/u].

Edit: The temptation to link to a video...