SELECT @sql = 'SELECT intID, strDescription, strID ' + CHAR(10) +

'FROM #TEST ' + CHAR(10) +

'WHERE strID IN( ''' + @strList + ''') '

This should work

This is basically a warning message, however try to create a script with both the stored procedures together in a single file with the called procedure at the top and...

Thanks Ryan and others for your quick replies I am going move the SQL files out of the compressed drives.

Hi, Thanks alot for the link, its very informative, however I have a little different issue infront of me, basically I want to read all the Time Zones and their...

while if you are using a SP then use

then wrap this in a transaction and run

BEGIN TRAN

INSERT INTO @t (fieldB) SELECT afIEldhERE from @T1

update @t1 set filed = (select...

Yeah it should work , however BEGIN and END optional tags may be useful if you want to add anything in addition to just this code block

DECLARE @status varchar (10)

SELECT...

Well,

I did not understand the questions properly, however from what I understand, if you want to insert the output of a SP call to a temporary table, the first thing...

Hi,

If time permits its always a good idea to follow a professional approach of analysing the dependencies and equivalent functions and datatypes in SQL Server and writing the Stored Procedures...

Hi,

Is there any specific reason why you want to use T-SQL Stored Procedures instead of the DTS import data functionality from the SQL Server Enterprise Manager.

Thanks

I don't think there is a way to add a leading 0 to the month unless you want to use convert function and concatnate with a 0 in front, which may...

I think you have missed one parenthesis and added a comma extra

declare @zcmSBA_V_SUBSTATIONID varchar(15)

declare @zcmSBA_V_WONO varchar(6)

declare @zcmSBA_N_JONO numeric

declare @zcmSBA_I_COSTTYPE Int

declare @err int

DECLARE @retItems VARCHAR(1000)

DECLARE @retAllocAmts VARCHAR(1000)

SET @retItems =''

SET @retAllocAmts=''

 SELECT    

 zcmSBA_V_TRXNO...

Well, there is one issue though which may not be the case like if say a company name is repeated for the city then it would also appear when we...

Yeah, this is a better alternative.

Thanks

Hi,

Can anyone throw some light on OSQL , how to use it and the benefits rather comparison with ISQL, I am so used to ISQL rather I am not aware...

Hi,

Assuming your table name to temp this would work

SELECT COMPANY FROM TEMP WHERE COMPANY IN (SELECT COMPANY FROM TEMP WHERE CITY='LA') AND CITY='NY'