m.s.owen (1/13/2009)

---

Ideally I would like to implement the code as it fits in better with our infrastructure - specifically we can have one script which is version controlled and implemented...

Actually you don't need a cross tab/pivot....

IF OBJECT_ID('TempDB..#tblInv','U') IS NOT NULL

DROP TABLE #tblInv

CREATE TABLE #tblInv

(

ID INT ,

PartNo VARCHAR(10) NOT NULL,

TranType VARCHAR(7) NOT NULL,

Quantity INT NOT NULL

)

insert into #tblInv(id,partno, TranType,quantity)

select 1,...

Aaaah!! I forgot that I am in 2000 forum..;)

As per Books Online...

SQL enforces uniqueness of the column, which is designated...

Here it is....

SELECT * FROM sys.indexes WHERE is_primary_key = 1 OR is_unique_constraint = 1

jordonpilling (1/13/2009)

---

parsename!!!!!!!!!!!!! how have i never come accross this function before?!?! Cheers for that!

Following now works perfect:

SELECT BRANCH_NO,

BRANCH_STARTRANGE,

...

The best way to handle this is to create a maintainance plan with reindex/reorganize index task in it.

Look in Books Online for Maintainance Plans...

Jeff has an excellent article[/url] on running totals, you might want to have a look...

MrBaseball34 (1/12/2009)

---

SELECT e.EncounterID, SUM(ed.Balance) as TotalAmt

FROM ptEncounterDetails ed

INNER JOIN ptEncounterEncounterDetail eed

ON eed.EncounterDetailID = ed.EncounterDetailID

INNER JOIN ptEncounter e

On e.EncounterID = eed.EncounterID

WHERE TotalAmt >= 5.00 AND

...

Have you checked the execution plans? Can you attach those with the post?

Have a look at the following article http://blogs.conchango.com/jamiethomson/archive/2006/07/14/SSIS-Nugget_3A00_-Extracting-data-from-unstructured-files.aspx

I meant last index/statistics...

Add...

Indexes & Statistics

The guy, who is sitting 3000 miles away:D, has to add "you" in the default role "role" (i.e. Servers > Databases > SomeDatabase > Roles > Role) or create some...

There are some situations, for example, after an index is dropped, when the space information for the table may not be current. So, in order to have accurate results...

mikael (1/12/2009)

---

After reading a little about SSIS packages it seems really handy ...

But with the above ... would that not create some extra steps ... as I see it ......