Search results for query: *

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

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

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