How about this?

DECLARE @xloc INT ,

@yloc INT ,

@MinVerticalBoundary INT,

...

What part of the database can you re-design? If it is possible to alter the destination table,i guess it will be better. If you change the base table for the...

You said dbo.vHVC_CustomerContactHistory is a view right? Then, did u check the base table of the view from where the column is derived from?

; WITH CTE AS

(

SELECT A.ProductId , B.ProductColorId , B.ColorImage , B.ColorName

,RN = ROW_NUMBER() OVER(PARTITION BY B.ProductId ORDER BY B.ColorName )

FROM tblTableA A

JOIN tblTableB B

...

How about this?

if object_id('tempdb..#t1') is not null

drop table #t1

create table #t1 ( SERVERIP varchar(20), BASESCORE int)

insert into #t1 (BASESCORE,SERVERIP)

values (5,'192.168.0.1')

, (9,'192.168.0.1')

, (3,'192.168.0.2')

, (3,'192.168.0.2')

, (5,'192.168.0.3')

, (9,'192.168.0.4')

, (9,'192.168.0.4')

select SERVERIP

...

One note on Sean's query. if the SKUs have trailing spaces, then u will not have the trailing spaces cut of.

i may do this:

create function udf_TrimTrailingZeros

(

@Input varchar(50)

) returns varchar(50)

as begin

set...

Its a hard task. Can you identify the SKU based on the company that sends them? If Yes, then it becomes relatively simple but not fully covered. What if the...

Try this:

SELECT DISTINCT T1.fk_fha_number

,T1.date_firm_commitment

FROM mf_insured_loan T1

LEFT JOIN F47FirmCommitment T2

...

Check this out :

DECLARE @TempTable TABLE

( InvoiceDate DATETIME , Ct INT )

INSERT INTO @TempTable (InvoiceDate, Ct)

SELECT '01 NOV 2005' ,...

Your reports will query only single month every time or are u planning to find all the distinct months in ur data and create a report ? You input to...

CAST it again as CHAR/VARCHAR and concatenate.

Steve, please take a gander at this article : Forum Etiquettes[/url].

The problem u have seems to be trivial. But to give u a coded answer, we need to some data...

Not a hard thing to do, but let me ask u one question ; how many distinct months are u expecting to be present in ur source table?

the new sample data confuses me. For 3849 with item_status = 40 , the order_status is "completed" as per ur data, but for 3848 it is Partial. can u pls...

Whats your expected output for the sample data you've given ?