Hi, I am trying to import data from excel file into SQL Server using SSIS. One of the column in excel file having most of the numeric values and...
Hi All, I want to use XIRR function of Excel using SQL Server. For example, i have following data in my table. Col1 Col2 ----...
Hi All, Is it possible to insert log information of DTS package to the User define Table ? I am aware of that we can have a DTS log into file. Thx
Hi All, Please have a look into the below code. I have tried to simplyfy my business logic for giving you example. Declare @v_Table TABLE ( MyID...
> Rajiv and Mona are flying to Australia for a two-week vacation to > celebrate their 40th anniversary. > > > >Suddenly, over the public address...
I am getting following error on executing the task: Copy Tables Data from One server to another server. [SQL-DMO]CreateFile Error on...
Hi All, I have one frequently used table with 40 columns and i need to alter schema and could have 160 columns. Should i go for 160 columns in a...
Why its not giving me Error ? Select 'a','b' Order By 2+2
Hi All, I am using SQL Server 2000. Everything was working fine till morning and suddenly getting error "Class not registered" on clicking create...
Hi All: How can we know that which Cluster/Noncluster indexes is used by SQL Server for a particular Query. Also, can anybody point out how to...
Hi All: One of my client has copy+pasted .mdf & .ldf from one machine to another machine and attached it over there. I dont want to allow him to do...
Why following query gives error for out-of-range date-time value though its not going inside the case ? SelectCase When...
Following is the SP that grant permissions to the user at once. Procedure expects two parameters ( DatabaseName & UserName ). One can easily modify...
<pre>Create Function No2Word ( @StrNo Varchar(100))<br />Returns Varchar(100)<br />As<br />Begin<br />Declare @StrRet as Varchar(100)<br />Declare...
Separate names with a comma.
