ALZDBA (12/9/2011)

---

Keep in mind if your date columns are of datatype datetime don't use BETWEEN but use

col >= @begin and col <= @end

SQLServer has an issue with datetime data...

There are several possibilities, but without sample data, it's difficult to determine which is best. Here are just two options.

WITH DupeCheck AS (

SELECT id, date, time, location, cardnumber, amount,...

CELKO (12/9/2011)

---

SELECT DISTINCT T.trans_id,

@in_start_date AAS report_start_date

@in_end_date AS report_end_date

FROM Calendar AS...

HowardW (12/9/2011)

---

I did consider that. It's easy enough for stores being deleted, but I can't currently wrap my head around the logic to work out the sphere of influence for...

HowardW (12/9/2011)

---

All I'm trying to do is, with a list of stores (about 120) and a list of customers (about 2.3 million in real life) to assign each customer a...

JonFox (12/8/2011)

---

I think you may be trying to do something like this:

WHERE (H.SALESSTTUS = 1 AND

H.SALESORIGINID IN ('DSM','DSM-Trf') AND

...

There should be another error message before this one that will give you details about the exact error that occurred. Without that previous error message, we can't really tell...

I thought that the FOR XML PATH('') solution was probably not the best solution in this particular case, so I didn't test it....

FOR XML PATH('') needs to be handle any data that...

Why is that the requirement? Is this for a class?

You want to...

If you are planning to export these, you're better off doing this in SSIS rather than T-SQL. In SSIS, you can specify the delimiter and automatically include headers.

Drew

Here is a different approach using a CROSS APPLY.

SELECT PetID

, p.PetName

, pd1.DDate AS Date1

, pd2.Date2

FROM @Pet AS p

INNER JOIN @PetDetail AS pd1

ON p.PetID=pd1.PetDetailID

AND pd1.DType = 14

CROSS APPLY (

SELECT TOP (1)...

I prefer using FOR XML PATH(''), because it

1) automatically handles the conversion

2) automatically handles NULL values

If you're working with character data, you do have to be careful with certain restricted...

PIVOT is probably not the right tool for the job, because it doesn't provide grand totals. The correct tool depends on exactly how you are using this data. ...

I would go even further. For your own sanity, your whole data...