Search results for query: *

PLease do help me with this script and I can't create another table ..possibly something like temp table another thing is that its not just 4 emp_id's may be it can be more and the series starts from 0050000000.Please do help me with this

One more thing..No duplicates should be there for the emp_id

I have a single table with 2 emp_id and its data inside.Now I want to duplicate the dataset. emp_id (varchar(13)) emp_name -------------------- -------- 0011275286 manu 0011275290 Anush starting serious 005....01(its length should be only 13) and then say...

I need to query the data from 3 tables in 3 different servers.Basically a union of these 3 tables.please help me out 10.50.200.139 (server),order(database),table1 10.50.200.139\CIG (server),product(database),table2 10.50.100.142 (server),sales(database),table3

I have 2 tables. Table 1 emp_id Duplicated_emp_id 103 501 103 502 103 509 205 717 205 689 316 890 316 790 316 280 316 999 table 2 (Main Table) emp_id emp_name emp_address 103 Manu adffsdfsd 205 anu dfsdfsdfs 316 vinu rttretre First step is to check whether there is a corressponding...

There is no join shown for the third table.I think I didn't put it properly..I need to get all the data from table1 and the matching dataset from table 2 and table3 (where the id's should match)..Sorry for not putting it properly

Here I have 3 tables and I need to join them with the following criteria.Please help me out.. id emp_name emp_address 1 Manu sdfsdfdsfs Table-1 2 Anu sdfsdfdsfsdf 3 Vinu sdfsdfsdfsdf id age sex 2 12 m 3 34 f Table 2...

I have a small problem where I need to have a type converion process in DTS when using an ActiveX script. eg: DTSDestination("check_number") = DTSSource ("check_number") + nCounter * 1000 Here the destination is varchar and Source is also varchar..Now I need to cast the source in to long or...

Hi there..thanks a lot..This Query is working in the query analyzer perfectly but as I use the same query in the Execute SQl task in the Dts package it says invalid object name #Temp and its not even parsing it properly.PLease help me with that

I think the way the sql team understood was different..Hope this will explain it more... employee table id Employee_id Name age Sex 1 300 Manu 23 m 2 301 Anu 45 f 3 302 Vinu 56 m Now I want to duplicate...

I want to duplicate each record 100 times in a table with a different unique key(not a auto generated one).Basically say a table in sql server has 100 records with a unique loan number(not auto generated)then I wanted to duplicate each record 100 times with only the change in the loan...