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...

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

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...

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 =...

does any one know how to create dynamic variables

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

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.

guys ive written a script update row by rows on a table but i get this error i know its something to do with replication but how do i resolve it. Server: Msg 18750, Level 16, State 4, Procedure upd_F1E69E45D5304681833AD6E92EE73B6B, Line 51 INITCOLVS: The parameter 'nickname' is invalid.

hi guys.... I have a script to write which is converting date which is stored as varchar(yeh i know) for example the data is currently in the format of 04/2004 and needs to be 2004/04 the columns all consists of data such null Y??? dhdhdh etc I have an idea of what to do but just wana see...

hi how would i update a table and change the date from mm/yyyy format to yyyy/mm format

hi guys does ne one know how to select all the rows from a table where the date is in the correct format dd/mm/yy else dont bring these results out.

hi huys i ahve a table which i need to get only disticnt values from for example select disticnt staffname,creationdate,etcet from tablename but when this happens duplicates appear to .. ive tried select etc etc from tablename Where staff IN (Select staff from staffviewsource Group...

Hi guys can you help im running a distinct against a column but its still bringing out duplicates ne idea for example when i run select disticnt name from table it works fine but whe i run select distinct name, creationdate from table it brings out duplicates ne idea Please

guys how do i call a stored procedure from a view thanx

how do i make a copy of a table what i am trying to do is copy a table into a temp table. the orginal table has 32 columns and i dont feel like recreating that manually as my temp table is there a way of copy that table so it has all the same column headeing ect when i display it as a temp...

hi i would like to select a database with a variable such as use @variable but use will not allow me to use a variable is there any other way to swictch to a different database

hhi how do i display all database names on the server is there a View in the master Table

hi can some one help me or giveme some advice.. I have a column in table which is of datatype image it contains data in the format such ,,,,,,,,,,,,,,,,,1000000,\\temp,,,,,,, I need to search through this and insert a value at a certain point(the 99th comma), can any one help me obvously ill...