that is not a valid xml/html entity character;

it has to be escaped as [amp]pound; or & pound;(no space between...hard to describe html on the forum)

http://www.w3schools.com/html/html_entities.asp

the full list of entities to...

this index:

CREATE NONCLUSTERED INDEX other_systems on MyTable(

other_system_id ASC

)

INCLUDE (other_system_key)

would be good for qa query like

SELECT

other_system_id,

other_system_key

FROM MyTable

WHERE other_system_id = 42

it would not benefit a query...

i know you can force a query to use a specific index, would that help?

SELECT ContactID

FROM Person.Contact WITH (INDEX(AK_Contact_rowguid))

i do it the same way, strictly because I'm sending individualized emails; the typical "Dear [Firstname]" emails to each email address i get from multiple rows in a...

try this at the end, instead of the wordier version; i'm using isnull to do the same basic logic as the if statements.

--even this test is not necessary...but left so...

that was a minor syntax issue...the where statemetn was occurring before the join;

change to this:

SELECT

lw.name_code, lw.nc_seq, lw.name_type, lw.age, lw.race, lw.sex,

split.ItemNumber,

Item = CAST(REPLACE(QUOTENAME(split.Item,'"'),'"','') AS integer)

FROM [FAYOSSIRMS].[rms].[dbo].[lwnames]...

where the sample values 'abcd' and 'ijkl' there to show that the clientid is alphanumeric, or are all the id's really numeric?

if they are numeric, you can convert them to...

remove the GO statements.

a GO statement ends the previous batch,and destroys the declared variables as well.

if you remove the GO statmeents, the variables will still be there, and you are...

assuming all the values are numeric, you should explicitly convert it to int inside the sum:

SUM (CONVERT(int,ZL_Count))

alternatively, the better solution is to make sure your destination table has that column...

so...yo want elapsed time converted to years:months:hours:minutes:seconds, and...

rounding inside the sum can lead to some varying results;

look at this based on your sample data...the rounding to money is quite a bit different.

/*4470487.674470487.76384470487.66999997*/

select SUM(convert(decimal(10,2),number,2)),

SUM(convert(money,number,2)),

sum(round(number,2))

from #temp

I had a requirement like that, and I generated the reports separately,and then used pdfmergerSB545.jar to join multiple PDF's together; in that way, i was able to get some reports...

nathan 7372 (3/23/2012)

---

Hello All,

I'm experiencing some unexpected behavior using rounds and sums on a floating point column. This is my query.

SELECT

sum(round([Refund],2))

FROM [MyDatabase].[TotalRefunds]

The...

the spaces in the file names makes it hard to do also;

i tried splitting the data on the slahses, and i'm not getting all teh possible results so far.

with mySampleData(id,val)

AS

(

SELECT...

if that inner function...