vaibhav.a (4/20/2009)

---

i want to perform this task using stored procedure, as I have to insert data in multiple table from multiple excel files at a time...

plz help me

thank...

Glad you got the answer..

You may want to check out the below link

http://www.sqlservercentral.com/articles/Miscellaneous/3174/

table design is purely based on the requirement.

Are there any other requirements around these emails? i.e if there is any change to the Body for a Line of Business do...

Hi

Please take some time to put a good requirement/question 🙁

Hi

I would prefer to go with SQL Server 2008 instead of 2005. 2008 has somany featurers.

But it would be great if you could list out what are the difficulties you...

Hi

You need to specify the datasize of the NVARCHAR2 datatype.

CREATE TABLE "tblZipCodes_Sales_2009" (

"sZipCode" NVARCHAR2(100),

"SalesRegion" NVARCHAR2(100)

)

How much...

I would go with PL/SQL, it is simple to manage...

it should be same as calling any other stored procedure, only difference is interms of Driver.

Sample String:

Provider=IBMDADB2.DB2COPY1;Data Source=TM_REPORTING_00004;Persist Security Info=True;Password=123456;User ID=rfuser

hi

Check out the below link(which does the debug using VS)

http://support.microsoft.com/default.aspx/kb/316549

Also please post some description about your output columns like ex: 'Sum251'...

I am curios to know why do you want to store the "Oder by" in table.

check out the below link, This will give you the function to reverse a string with out using REVERSE.

http://blog.sqlauthority.com/2007/05/01/sql-server-user-defined-functions-udf-to-reverse-string-udf_reversestring/

I always prefer to use existing functions, if they are...

Hi

You can use below script:

DECLARE @t TABLE (split_col VARCHAR(100))

INSERT INTO @t VALUES ('3:16')

SELECT split_col,

SUBSTRING(split_col, 1, CHARINDEX(':', split_col)) First_val,

SUBSTRING(split_col, CHARINDEX(':', split_col) + 1, 100) Second_val

FROM @t