Hi,

Try to execute with full qualification of the procedure like

Exec DB.Owner.MYPROCEDURE

I mean

Records must be in this specific order:

OnlineDotCom (Company totals)

Memphis (District totals)

0001 (storeNbr totals)

0002 (storeNbr totals)

Tupelo...

TheHTMLDJ (11/20/2009)

arun.sas (11/20/2009)

Yes, but not now, because you edit the first post, and what formats do need...

Yes, but not now, because you edit the first post, and what formats do need to retrieved?

From...

Hi,

Post the schema of the booksales table, its helpful us to understand better.

Hi,

Jack Corbett approach is correct, even though to avoid accidentally drops by developers, and some time by the DBA, you create the dummy view WITH SCHEMABINDING and use your table,...

Hi,

Use the global temp table (##temp tables) in the dynamic executions.

Hi,

Thank for mentioned my statement updates only the unique value to all rows,

First you insert the UID into the temp table

Like

SELECT saNumber,NEWID()TEMPID1 into #TEMPID

FROM [Table]

GROUP BY saNumberthen...

Hi,

This may be retrieved quickly, but not understand in this area,

DATA_CODE REEL_NO

M10 1138935111

E10 1138935111

M10 113893511L

E30 113893511L

M10 113893511R

Z20 113893511R

M10 1138935XXX

E10 1138935125

E30 1139032102

Z20 1139081101

I want to check if M10 with reel_no...

declare @id uniqueidentifier

set @id = NEWID()

UPDATE [Table]

SET

ID = @id ,

Flag = 1

WHERE saNumber IN(SELECT saNumber FROM [Table] GROUP BY saNumber HAVING...

Hi,

Its may suits you, Try this

UPDATE [Table]

SET

ID = (saNumber*100) ,

Flag = 1

WHERE saNumber IN(SELECT saNumber FROM [Table] GROUP BY saNumber HAVING COUNT(*) > 1)

Hi,

Use the RANK.

Ref:

http://www.sqlservercentral.com/Forums/Topic819194-145-1.aspx

Hi,

How may record you want to display, if it’s for the report purpose, then use from REEL CODE and to REEL CODE and between conditions to reduce the retrieve...

SELECT REEL_NO,

max(CASE WHEN CODE = 'M10' THEN 'YES' ELSE NULL END) AS M10,

max(CASE WHEN CODE = 'C10' THEN 'YES' ELSE NULL END) AS C10,

max(CASE WHEN CODE = 'E10' THEN 'YES'...

Hi,

Ref the valuable Jeff article, The "Numbers" or "Tally" Table: What it is and how it replaces a loop like: (One Final "Split" Trick with the Tally Table) Link:http://www.sqlservercentral.com/articles/T-SQL/62867/