Recent content by 19511950

I have about 50 cat's and 500 id's. From each cat i need only the top 1. How to paste cat to each statement to get id?

I need pass cat in each statement update tbl1 Set num=1 where id in (select top 1 from tbl1 where cat='A') update tbl1 Set num=1 where id in (select top 1 from tbl1 where cat='B') update tbl1 Set num=1 where id in (select top 1 from tbl1 where cat='C')

Hi, I have a table that has id,cat & num fields. Each cat has multiple ids, Num is 0 I need to create sp that will pick top 1 in each category and update field Num to 1. id cat num -- --- --- 1 A 0 2 A 0 7 B 0 6 B 0 2 C 0 7 C 0 Regards, Mark

Tony, Thank you very much.It works. Mark

I need both. (1,15,17) and (ALABAMA,INDIANA,KANSAS)

How to do it?

it should be the same datatype. select convert(char(3),123)+'456'output:123456 select 123+456 output:579

Hi, I can choose multiple rows from drop down list and get value into the query. select * from table where StateID in (1,15,17). Also I need to pick the State Name in the same sequence: "You choose ALABAMA,INDIANA,KANSAS states." Can I get the value of ID? <select name=Date2 multiple>...

Thanks jhall01, The problem still exist. The DTS package was created locally under my id and I have all rights as administrator. DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error Detail Records: Error:5...

Hello, I've got the same problem. The DTS successfully execute from 'Data Transformation Services', but when DTS schedule to run in SQL Server Agent it gives the same error as above. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError...

did I do something wrong? I place this code into Visual Basic ActiveX Script. Error:Microsoft VBScript Compilation error Error Description: Expected Identifier ------------------------------------------------------- Dim, FSO, fileloc, file set fso = CreateObject("Scripting.FileSystemObject")...

Can you be more specific, please, I've never use ActiveX scripts in packages. How and where show I create this procedure?

Hi, Everyday I need to create (or update) excel file (name.xls) that will contain fresh data from sql server db. When I try to run DTS second time it tells me that this file exist. How to delete existing file from the folder using same DTS? Thanks, Mark

select distinct A.Last_Name, A.First_Name From Member A, Member_Designations B Where A.Member_Number=B.Member_Number Order By A.Last_Name Asc

Any code doesn't work. Maybe problem with the Mac browser 5.1