Not sure, but give this a try:

with UniqueBookings (

MeetingID,

BookingID

) as (

select distinct

MeetingID,

BookingID

from

...

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...

andrewd.smith (11/21/2008)

---

This only works if @@DATEFIRST = 1 (Monday)

An expression that returns the date of the Sunday in the current week regardless...

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....

Also, on my server here at work, the above returns tomorrow (Saturday), not a Sunday.

Given 2008-11-19 which Sunday do you want, 2008-11-16 or 2008-11-23?

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,...

john.steinbeck (11/21/2008)

---

Ok, row 85 is a new ID, 101 and 102 are new ID's and so is 103 ending @ 111...

when i get the data, it's not ballooned out like...

Could you please provide some examples...

Not true!...

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.

Hope the following (with changes) helps.

create table dbo.Orders (

OrderID int,

UserName varchar(25),

OrderDate datetime

);

create table dbo.Tasks (

...

Here is what I am trying to get at:

what you are getting ...

I have taken a closer look at your code, and it won't work. I just noticed the wildcard you are trying to use in the BUL INSERT pathname, and...

Ravi,

I actually want to point you to both articles listed below in my signature block. The first, which you already have been referred to, will help you get better...