Search results for query: *

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(

...varchar(200) declare @duplicatecolmap varchar(200) --declare @masterV varchar(200) --declare @DuplicateV varchar(200) select @maxCount = count(*) from #tablenames set @minCount = 0 while @mincount < @maxcount begin print 'outer loop' select top 1 @tablename = tablename from #tablenames...

...varchar(200) declare @duplicatecolmap varchar(200) --declare @masterV varchar(200) --declare @DuplicateV varchar(200) select @maxCount = count(*) from #tablenames set @minCount = 0 while @mincount < @maxcount begin print 'outer loop' select top 1 @tablename = tablename from #tablenames...

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

thanks alot mate if i was to do it by looking inanother table(temptable) for example if i stored 12345 34567 the following wont work select col1 from table1 where like (select col1 from table2) ne suggestions.. please and thanks again

thnak you but the fact is i have more then one value then 123 for example i have col1 123456 786543 555555 how can i incorporate the like statement to check all

hi i know you cant do regex in SQL but i ahve the following problem bascially i want to bring out all the values which have the following values in includes in them for example 123456 666555 777888 so that should bring out abc123456 cde666555 efgh777888 can any body help me.

hi can some please help me urgently ive made mwethod ocf creating a mail and sending it it arabic it works when it is sent to a outlook client but when its sent to hotmail its mumble jumble any ideas my code is below Response.ContentEncoding =Encoding.GetEncoding("Windows-1256")...

guys when i try to update a certain column in a databse table i keep getting this error message any ideas ? please Server: Msg 18750, Level 16, State 4, Procedure upd_F1E69E45D5304681833AD6E92EE73B6B, Line 51 INITCOLVS: The parameter 'nickname' is invalid.