Hi Garry,

I have done some work (with help from these forums) recently using a history table through a trigger on the live table.

On first entry of data to the table,...

Hi Ishaan,

A little more information is necessary I think.

The Select statement would be good.

Hi Andrew,

You can happily use the xp_command shell e.g:

EXEC Master..xp_cmdShell 'MOVE "\\Server\Drive\Dir\*.xls" "\\Server\Drive\Dir\Archive\"'

EXEC Master..xp_cmdShell 'DEL "\\Server\Drive\Dir\*.xls"'

Have fun

Hi,

Sam - I am led to believe that instead of SELECTing what you want from the temp table - DELETEing what you dont want and then returning the table is...

Hi Greg,

Just do a search through the scripts section. Most of the things you want are actually already there.

I think this should suit your requirements:-

http://www.sqlservercentral.com/scripts/contributions/434.asp

Have Fun

Best regards

Hi,

If it helps - yes you can do away with cursors and still step through everything:-

No problems Bill.

Only knew 'cos i'd done the same thing myself.......

Bill,

Simple error mate.

You need to declare scale and precision when you declare a decimal variable. Otherwise it defaults to 0.

E.g. Declare @Variable Decimal(10[Scale - number size to right of decimal...

Worth a read for a view from the other side of the fence.......

http://weblogs.asp.net/fbouma/archive/2003/06/16/8731.aspx

http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx

http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx

Frank: How u doing? Have you read these?

Hi GrassHopper,

I must admit I have used this form of sql a lot just recently - dangerous saying Dynamic in these posts, it becomes a massive discussion on the subject and you...

Hi Farrel,

I take it you are trying to do something like:-

Declare @Variable1 varchar, @Variable2 varchar, @Variable3 varchar, @Variable4 varchar, @Counter int

Then step through the variables using something like:

FOR @Counter =...

Sorry - do a find and replace with your table and column names.

I used columns: DataID, ParentID, Data

Table: Directories

Have fun

Bill,

Bit long winded and untidy, with a bit more time it could probably be cut down but:-

DECLARE @DataID int,

 @MaxDataID int,

 @ChildID int,

 @MaxChildID int,

 @ChildID2 int,

 @MaxChildID2 int,

 @ChildID3 int,

 @MaxChildID3 int,

 @ChildID4 int,

 @MaxChildID4 int,

 @ChildID5 int,

 @MaxChildID5 int

 SET...

Dave: If it wasn't meant as an insult, then I apologise unreservedly. It certainly felt insulting yesterday, insinuating my work coleagues are Turkeys.

Frank: (Implication of personal stupidity....) Same goes.

I understand the...

Shane: Works an absolute treat.

CAGreensfielder: Much appreciated. I will PM you and give you my mail address. I do have it working now but like to see all the different...