Viewing 15 posts - 23,596 through 23,610 (of 26,490 total)
Your problem is here:
SET @dRetVal =...
November 21, 2008 at 2:28 pm
Without testing, this should work.
UPDATE TableA SET
MeetingID = B.MeetingID
FROM
TableA AS A
INNER JOIN UniqueBookings AS B
...
November 21, 2008 at 2:07 pm
Could you report with corrected example? I'm having a Missouri moment and you need to Show Me.
I think it should be easier if it is reversed.
November 21, 2008 at 12:45 pm
psangeetha (11/21/2008)
Below is the query I'm using to find the status of the objects,
select name,status,refdate from sysobjects
I know the refdate in this table is the date the...
November 21, 2008 at 12:34 pm
Not sure, but give this a try:
with UniqueBookings (
MeetingID,
BookingID
) as (
select distinct
MeetingID,
BookingID
from
...
November 21, 2008 at 12:26 pm
More work for you. Would you please explain the PMT_FREQ, PMT_FREQ_MULT, any gotcha's we may need to know (like no payments due on Saturdays or Sundays, or official holidays).
I'd...
November 21, 2008 at 12:11 pm
andrewd.smith (11/21/2008)
select getdate() + 7 - Datepart(dw, getdate())
This only works if @@DATEFIRST = 1 (Monday)
An expression that returns the date of the Sunday in the current week regardless...
November 21, 2008 at 12:04 pm
Directed more to the OP, but based on your suggestion, which didn't work on my servers here at work. It returns the Saturday following the given date, not Sunday....
November 21, 2008 at 11:09 am
Glen (11/21/2008)
select getdate() + 7 - Datepart(dw, getdate())
Also, on my server here at work, the above returns tomorrow (Saturday), not a Sunday.
November 21, 2008 at 11:00 am
Glen (11/21/2008)
select getdate() + 7 - Datepart(dw, getdate())
Given 2008-11-19 which Sunday do you want, 2008-11-16 or 2008-11-23?
November 21, 2008 at 10:57 am
Yes, I got the image via PM. You may want to see if you can get it into this forum thread so others can see it. If needed,...
November 21, 2008 at 10:52 am
john.steinbeck (11/21/2008)
when i get the data, it's not ballooned out like...
November 21, 2008 at 10:37 am
marty.seed (11/21/2008)
Hey there group,I need to build a function that takes in a date and then returns the corresponding Sunday to that date.
Any ideas?
Marty
Could you please provide some examples...
November 21, 2008 at 10:36 am
andrewd.smith (11/21/2008)
This is one of those situations where using a cursor is the more natural approach and will probably be more efficient than any possible single query approach.Andrew Smith
Not true!...
November 21, 2008 at 10:23 am
Different people may use different settings for tabs. I set up SSMS to replace tabs with spaces which eliminates this as an issue with my formatted scripts.
November 21, 2008 at 10:20 am
Viewing 15 posts - 23,596 through 23,610 (of 26,490 total)