Viewing 15 posts - 6,631 through 6,645 (of 8,416 total)
Jeff Moden (11/12/2009)
How would you do what the OP requested using SSIS? ie. Append it existing file if it exists or create a new file if it doesn't.
Just use...
November 14, 2009 at 4:02 am
Steve Jones - Editor (11/13/2009)
Sent George a note. We'll sort him out.
Awesome Steve - thanks!
November 13, 2009 at 11:48 pm
Off topic: Hey Steve, is there anything that can be done to help George out here? It's just a small thing about user names and numbers.
November 13, 2009 at 4:58 pm
peter-757102 (11/11/2009)
Paul, lets not use words such as "cheat" here.
Why not? I think you're reading something into that which isn't there!
peter-757102 (11/11/2009)
November 11, 2009 at 11:27 am
What about...
select original_security_id from sys.dm_exec_sessions where session_id = @@spid
...?
You might need to mangle the binary a bit. Other than that, no idea.
Paul
November 11, 2009 at 6:00 am
I would check first that the procedure named wasn't being run explicitly at the SERIALIZABLE isolation level.
Having looked at the graph (I didn't have time earlier) it certainly...
November 11, 2009 at 5:25 am
Hey Jeff,
Top-tier article, rated 5 stars because that's all there are 🙂
I just hope those handrails are welded on.
The only thing I dislike about this method is the name. ...
November 11, 2009 at 5:16 am
Andrew Gothard-467944 (11/11/2009)
If the power goes down and the system's running off the UPS, presumably they'd be battery?(I'll get my coat)
:hehe::laugh::hehe: ... Oh dear!
November 11, 2009 at 3:43 am
COldCoffee (11/11/2009)
Thanks Paul,but i should not use CLR Procs nor i am allowed to create functions. I need simple T-SQL query to get it done
Thanks for mentioning that up front.
COldCoffee...
November 11, 2009 at 3:39 am
jason.gerding (11/9/2009)
select (SELECT Count(CallLog.ClosedBy)*1.0 From [Support].[dbo].[CallLog] WHERE ClosedDate Between '2005-01-07' and '2010-01-08')/(SELECT Count(CallLog.RecvdBy)*1.0 From [Support].[dbo].[CallLog] WHERE RecvdDate Between '2005-01-07' and '2010-01-09')...
November 11, 2009 at 2:13 am
CREATE VIEW dbo.CrystalBalls
WITH SCHEMABINDING
AS SELECT Egg FROM
(
VALUES
('Egg'), ('Egg'), ('Egg'), ('Egg'),
...
November 11, 2009 at 2:07 am
Of course, I cheated slightly - it depends on the CLR function below: 😀
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Globalization;
public partial class UserDefinedFunctions
{
[SqlFunction
...
November 11, 2009 at 1:54 am
SELECT dbo.FormatDateTime(CURRENT_TIMESTAMP, N'dd-MMM-yyyy hh:mm tt')
November 11, 2009 at 1:48 am
It's certainly plausible...;-)
And it does help to be psychic with a lot of these questions.
November 11, 2009 at 1:13 am
Viewing 15 posts - 6,631 through 6,645 (of 8,416 total)