Recent content by camy123

hi im running a DTs package where i would like to create a excel filename on the fly(using Date) cuurently i just have a default filename and then rename it but it doesnt work ne one know why please Function Main() Dim FileDate Dim DateString Dim FSO Dim File FileDate = Date DateString...

cheers i was woinderinfg iff there was a datediff version but i suppose that wouldbe much longer.. thank you .

guys justa quickie here..... how can i compare to dates to find out which one is the most recent using datediff etc .. cheers guys

0 BFB0454B-BB66-4AA6-B183-0D9F8B9743F6 no action taken (0 row(s) affected) (0 row(s) affected) 1 BFB0454B-BB66-4AA6-B183-0D9F8B9743F6 no action taken (0 row(s) affected) (0 row(s) affected) 2 BFB0454B-BB66-4AA6-B183-0D9F8B9743F6 no action taken (0 row(s) affected) (0 row(s) affected)...

nah the same row keeps loooping cuase this statement update dupes set checked = 1 where ' + @mastercolmap + '= @masterv' should update a checked column to 1 so it moves on to the next row but becuase it is not updating the same row keeps coming up . :0(

hi can any one help me please ive written this script to update dynamically but none of the updates work .. does any one know here is the code thanks in advance declare @maxCount int declare @minCount int declare @innerloopmincount int declare @innerloopmaxcount int declare @tablename...

here is my actual code ne body see what going wrong the below if the part which is not updating ----- --- update dupes set checked = 1 where ' + @mastercolmap + '= @masterv' -------- the full code is below declare @maxCount int declare @minCount int declare @innerloopmincount int declare...

cheers sorry i know that this example does nto warrant Dynamic SQL i couldnt post my whole real code on here so i made a bad example sorry .. and thanks i put in set @i= 0 and it worked. but in my original code i have already instantiated this.. um............

hi can some one help me pls ive written a peice of code to update.. using dynamic sql but it wont update ... does ne one know why example code is... declare @sql nvarchar(2345) set @sql = 'declare @i int' + ' while @i < 10' + ' begin' + ' update dupes set checked = 69 where col001 =...

yeh i know but was tryna keep it dynamic with less code... basically tryan be to cleaver for me own good thanks ne hows mate rerally appriciate your time..

ok basically what i would like is to check 32 variables thats ive already declared. I would like to loop through this variables checking there values rather tyhen writing if statements for each variables the variables are called market1..........market32 so my aim was to create a loop example...

i would like to create variables on the fly for example @variable = 'masrket' + i -- i = index value of loop

does any one know how to create dynamic variables

Im not sure of the error to hand but does that mean theres no way to trap the error and allow the script to carry on...if @@error > 16

guys need your help please I have a store procedure runnign via scheduler and sql agent keeps aborting it when it comes to a certain error what i need is to nto allow the script to be aborted even tho there is a error there ne ideas Please