Viewing 15 posts - 7,801 through 7,815 (of 14,953 total)
Bob Hovious 24601 (11/11/2009)
I was just trying to figure out the picture Ian posted.
What picture?
November 11, 2009 at 8:42 am
Erik Kutzler (11/11/2009)
SUBSTRING(@[User::FileName],LEN(@[User::FileName])...
November 11, 2009 at 8:21 am
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.
November 11, 2009 at 8:15 am
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...
November 11, 2009 at 8:14 am
Bob Hovious 24601 (11/11/2009)
... or is that an ace of spades? ....
.... a hooded apparition with glowing eyes?
(DANG, this is a...
November 11, 2009 at 8:10 am
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...
November 11, 2009 at 8:09 am
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...
November 11, 2009 at 8:02 am
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...
November 11, 2009 at 7:56 am
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...
November 11, 2009 at 6:56 am
The error is because of the comma after PRHours.
November 11, 2009 at 6:49 am
Matt Miller (#4) (11/10/2009)
Michael Valentine Jones (11/10/2009)
November 10, 2009 at 12:41 pm
Hey, I say Enterprise Class servers/software deserve Enterprise Class hammers! That's all! 😀
November 10, 2009 at 12:37 pm
Steve Jones - Editor (11/10/2009)
I'll see if I can whip one up in Excel or SSRS. ....
On a site all about SQL Server, he proposes using Excel instead of Reporting...
November 10, 2009 at 12:36 pm
Steve Jones - Editor (11/10/2009)
Hammers aren't fun for technical equipment on the fritz. Now a slingshot.....
Depends on how you define the word "hammer"[/u].
Edit: The temptation to link to a video...
November 10, 2009 at 12:33 pm
Viewing 15 posts - 7,801 through 7,815 (of 14,953 total)