sorry, but xml always seems to get mangled in the post body. here's the function as an attachment.

EXCEPT is not optimized to perform like a join. it's the same as doing thing as you dumping your first query into a temp table and then deleting any...

this will group anything to Sun-Sat weeks for each month:

select

year([your_date_column])*100 + month([your_date_column]) as year_month,

(day( [your_date_column] ) + 6 - datepart(weekday,[your_date_column])) / 7 + 1 as week_number,

min(day( [your_date_column] )) as...

select replace(

replace(

replace(

convert( varchar(16), cast(1234.20 as money), 1 )

,'.','!')...

you can do it by transforming report services XML output into Excel's XML format.

http://spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx

the stored procedure must return some data item by which you can partition.

if you can group by some data item, then adding a page break before/after a group...

i assume you mean that the report exceeds excel's row limit and is split into 2 sheets when you export.

if so, you could add second table and have...

best to cast all expressions to a common type or cast the entire case statement to the desired type.

print is limited to 8K varchar and 4K nvarchar (since nvarchar is double byte).

PRINT msg_str | @local_variable | string_expr

Arguments

msg_str

Is a character string or Unicode string constant. For more information,...

how are you building your string? if you're attempting to concatenate 'regular' varchars together, they'll max out at 8000 characters regardless of what you're trying to stuff them into.

declare...

GSquared (7/14/2008)

---

Since the original example is using a string-split function to break it into rows, I'm pretty sure that's the desired input. But I think he already has what...

GSquared (7/11/2008)

---

Compare the sum of the list, and sum of the absolute values of the list. If it isn't equal, one or more value are negative.

select case

when

...

To me, a sub-query is dependent on the containing query. A derived table (table expression) is independent of the containing query. That's why the example below is invalid...

antonio.collins (7/11/2008)

---

Ken Simmons (7/10/2008)

---

You can use any, but you would have to do it like this.

Select CASE WHEN 0 > any ( Select @val1 UNION ALL Select @val2 UNION ALL...

Ken Simmons (7/10/2008)

---

You can use any, but you would have to do it like this.

Declare @Val1 int

Declare @Val2 int

Declare @Val3 int

Declare @Val4 int

Declare @Val5 int

Set @Val1 = 1

Set @Val2 =...