Viewing 15 posts - 2,236 through 2,250 (of 4,080 total)
I haven't worn a kilt since the last time I was in a wedding. It's a good feeling, and sporrans come in damn handy. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 1:45 pm
You might be right, but I think it's worth the risk. If you find it really does cause problems, then tell your developer that he has to do...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 1:20 pm
Think about this... the unused parameters do have a purpose. They are being used to save coding effort in the calling application.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 1:12 pm
I have lost my Zenlike tranquility and need to join Lynn for a walk in the desert.
Am I just being grumpy or does the OPs last...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 1:08 pm
I'll remember that the next time I take time off from MY job to help you out. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 1:05 pm
Essentially he is saying: "I want you to do more work, so I don't have to do as much." You COULD provide him with a list...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 12:26 pm
This is definitely NOT the place to ask urgent questions. I've got a solution for you, but first I'd like to know why this is urgent.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 12:22 pm
I'm not asking you to show all of your data, but some sample temp tables with a few rows apiece would be nice. I'm working at...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 12:10 pm
Potso,
SELECT DISTINCT is just like a GROUP BY, only it doesn't require aggregation functions. It is redundant if you are using GROUP BY, and adds nothing to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 11:52 am
Sorry about that.
CTE stands for "Common Table Expression." You can look up more details in books online (the help function), but it is basically like...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2009 at 9:09 am
The effectively places the records in the temp table in order of priority. This was necessary since an UPDATE statement cannot specify the order in which records should be updated....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 1:29 pm
You can use a CTE as the source for the update, like so.
declare @sampleSource table (rowid int identity(1,1),priority int) -- this would be your temp table
declare @sampleTarget table (rowID...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 1:17 pm
The effectively places the records in the temp table in order of priority. This was necessary since an UPDATE statement cannot specify the order in which records should be updated....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 11:53 am
select convert(varchar(30),dateadd(month,datediff(month,0,getdate())-1,0),112) as FirstDayOfPreviousMonth,
convert(varchar(30),dateadd(day,-1,dateadd(month,datediff(month,0,getdate()),0)),112) as LastDayOfPreviousMonth
Just change getdate() to your date variable or column.
Here's how the last day previous month works.
The function datediff(month,0,getdate()) returns the number of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 11:05 am
I have the following code. I would like to group on Month and year. I have tried converting datetime to varchar to change the format.That did not work. Running the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 10:58 am
Viewing 15 posts - 2,236 through 2,250 (of 4,080 total)