murgatroid (1/30/2013)

---

This is very nearly the same type of problem discussed in Phil Factor's SQL Speed Phreak challenge http://ask.sqlservercentral.com/questions/1227/the-subscription-list-sql-problem.html, which is also discussed nicely here http://www.simple-talk.com/sql/performance/writing-efficient-sql-set-based-speed-phreakery/. Besides being a...

Actually,...

Does this look like it's close?

;WITH Tally (n) AS (

SELECT 0 UNION ALL

SELECT TOP (

...

Abu,

I think my code will handle the sample you provided in your text, albeit it doesn't join the 3 parts into a comma delimited string (but that's easy).

On the other...

Has the world just come to an end and no one told me?

Overnight for me in Bangkok and I received not a single notification from SSC, not even from The...

That's assuming you use domain creds to log into SQL Server (domain authentication), otherwise it returns the SQL Server login.

If you're going back one month or 2 months to find 100 records, why do you even care about a date range?

;WITH Tally ([Date]) AS (

SELECT...

Not exactly clever nor pretty but this might get you close:

with cteOriginal (CompanyName, CompName1, CompName2, CompName3)

as

(

select 'A V H S L ALQUILER Y VENTA DE HOGARES', NULL, NULL, NULL union...

If you'd like me to take a shot at implementing my suggestion, can you provide some additional sample data...

You can probably make a change something like this:

SELECT [Day], MaleGuests=ISNULL(SUM(CASE Gender WHEN 'M' THEN 1 END), 0)

, FemaleGuests=ISNULL(SUM(CASE Gender WHEN 'F' THEN 1 END), 0)

I suggestion you make these changes:

SELECT

Institution_Number,

Attached_Account_Number,

[1]=MAX([1]),

[2]=MAX([2]),

[3]=MAX([3])

... (at the end add the following):

GROUP BY Institution_Number, Attached_Account_Number

Are you passing into the SP any parameters that are then used in the WHERE clause of the query?

If your answer is YES, then you may want to Google "SQL...

Why does this bring to mind the vision of...

Two ways I know of to do this:

1. In an UPDATE trigger, you can query UPDATE() function (http://msdn.microsoft.com/en-us/library/ms187326.aspx) to tell you if the column was SET by the UPDATE statement....

Is something like this close enough for you?

DECLARE @Expenses TABLE

([S.no] INT

,[Travel Expense] MONEY

,[Stay Expense] MONEY

...