Viewing 15 posts - 7,336 through 7,350 (of 10,144 total)
Alvin Ramard (9/21/2010)
Steve Jones - Editor (9/21/2010)
Keep up the bad jokes and we'll likely get 30 a day 🙂
A query walks into a bar, sees two tables and says: "May...
September 22, 2010 at 2:19 am
Michael Valentine Jones (9/21/2010)
You can just use the ROUND function to round the age up or down......
You can Michael, and there's a 50/50 chance it will work as-is here. Depends...
September 22, 2010 at 2:12 am
scott.pletcher (9/21/2010)
September 21, 2010 at 10:12 am
BenWard (9/21/2010)
Hi Chris,thats essentially what I'm doing but twice.. im trying to call that sproc from another and copy data into a table from that exec which sql cant do.
Oh...
September 21, 2010 at 10:06 am
Hi Ben, not sure if this is any good to you, I wrote it in a previous life and can't even test it here:
CREATE PROCEDURE [dbo].[CopyDiskFile]
@FileFrom VARCHAR(200), @FileTo VARCHAR(200)
AS
SET...
September 21, 2010 at 9:58 am
RichardDouglas (9/21/2010)
They sit nicely next to...
September 21, 2010 at 9:34 am
CirquedeSQLeil (9/21/2010)
Alvin Ramard (9/21/2010)
CirquedeSQLeil (9/21/2010)
So T-time is at 4? Sounds good to me:cool:Is it ok if I have coffee instead of tea? 😎
My powers of divination told me...
September 21, 2010 at 9:08 am
CirquedeSQLeil (9/21/2010)
Chris Morris-439714 (9/21/2010)
khanameerkhan (9/20/2010)
Is there any way to determine who deleted the database in sql server 2008.Look under tables and in cupboards for one of these :blush:
If SQL Server...
September 21, 2010 at 8:51 am
Have a read through Jeff Moden's excellent article[/url]. If you are still experiencing difficulty, then post again. It's a little tough going to begin with but you'll soon get the...
September 21, 2010 at 8:49 am
khanameerkhan (9/20/2010)
Is there any way to determine who deleted the database in sql server 2008.
Look under tables and in cupboards for one of these :blush:
September 21, 2010 at 8:43 am
drew.allen (9/21/2010)
Jeff Moden (9/20/2010)
I don't like the short version at all because it "lies".
That's very interesting, but, realistically, how often do people use nondeterministic functions like NEWID() in the comparison...
September 21, 2010 at 7:25 am
mail4sha (9/21/2010)
September 21, 2010 at 7:06 am
dbowlin (9/21/2010)
Ray K (9/21/2010)
WOTD: Coffee (as in I need some! :doze:)Lemon Zinger is my morning brew.
We have a zero tolerance policy to alcohol here :Whistling:
September 21, 2010 at 7:03 am
Jeff Moden (9/20/2010)
I don't like the short version at all because it "lies".
So a Simple CASE, which on the face of it should work quicker than a Searched...
September 21, 2010 at 6:25 am
So, why don't you just put "exec dbo.rpt_HS_BedsMI @insurer=@ins, @lwrDate=@lowerDate, @uprDate=@upperDate" at the end of what you've got?
September 21, 2010 at 6:04 am
Viewing 15 posts - 7,336 through 7,350 (of 10,144 total)