How do u call an Oracle procedure from a DTS? thanks Rosh
Can we have multiple instances of DTS running? We have a scenario where more than one client can invoke a DTS pkg at the same time. What happens in...
SQL Server Books Online should help.
Could someone elaborate the difference between fourth and fifth normal form Thanks
Need some help to generate a 10 digit Unique number. Something like 0000000000 1000000000 2000000000 .... .. 9000000000 9100000000 ..... 9999999999...
select loanno,max(dtevent) from kloanevent where (eventcode='Marked' or eventcode='Unmarked') group by loanno The above SQL should give you the max...
Btw ur original post had quite a few errors with the sql script and the xml doc.
Cut copy paste mistake <img src='/community/emoticons/emotion-1.gif' alt=':)' />
DECLARE @idoc int<br />DECLARE @doc varchar(1000)<br />set @doc='<root><br /><<img src='/community/emoticons/emotion-4.gif' alt=';p' />1...
Ok great [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />So I hope Ramesh u got what u want [8D]<br /><br />~ Rosh
I was looking at the syntax of the insert command INSERT [ INTO] { table_name WITH ( < table_hint_limited > [ ...n ] ) | view_name...
Hi Ramesh I guess u can use the default key word only in the insert command as in insert into test (sName, dDate ) values('e',default) In your...
if u look at the sql server help it mentions " Caution Although DBCC PINTABLE can provide performance improvements, it must be used with care. If a...
I have tried the evaluation of SQLDBControl. Great product. Would have loved to purchase it but I wonder if my organization would help out. I think...
I am goin ahead with client script for the concatenation. Best option. Thanks ~Rosh
Thanks for all the suggestions. The Normalisation problem is understood but the problem is there are a lot of properties. Desc1 can have 10 values...
I guess the table structure and data is not clear CustomerId has data 001,002 Desc1 for 001 - TS01;TS03;TS05 Desc2 for 001 - D01;D02 Desc1 for 002...
I need to write a query which would return rows grouped on a customer id for rows which satisfy a particular input criteria. (Without using cursor)...
Was not able to download the tool.e.g Lumigent's Log Explorer ~Rosh
Guessed as much. I always take a backup (utmost respect for the database) but unfortunately it was a friend. Was reconfirming.But was still hoping...
Separate names with a comma.
