Share your expected output as well for better understanding.

this would not hurt only if this store procedure is executed independently. if you are using this store procedure in side a store procedure then it could hurt u.

its a...

Nice question to end the year.

Happy New Year all Family members 🙂

May 2014 bring joy with enjoy 😎

please share more detail if possible share the sample data to help us understand the issue. so that we can answer 🙂

your Window User do not access to that particular DB. For the sake of connectivity you can use SQL Authentication Mode for that db.

you can use SSIS for this, its created for the very purpose. as its MSSQL to MSSQL you can use the FASTLOAD option to load data.

very good start of the week and QotD 🙂

Thanks for sharing Steve.

kapil_kk (12/19/2013)

---

Koen Verbeeck (12/19/2013)

---

kapil_kk (12/19/2013)

---

Koen Verbeeck (12/19/2013)

---

kapil_kk (12/18/2013)

---

HI all,

I have a scenario in which I need to execute the Stored Procedure which required input parameters.

e.g. usp_TestData ?,?

I have created user...

It not a very good idea to print data in Triggers, If you want to know how many updated are you should have a log table in which multiple rows...

++1, you need to move your files

you can...

Please also share the source table schema or query.

Try to execute the procedure without using 'dbo.ConvertTimeZoneFromUTC'. Table 'PartnerPlayer' is missing an index. (Missing a Primary key, there Should be). You can also use NOT EXISTS instead of Left...

this is your destination table or source table?

ChrisM@home (12/15/2013)

---

Each one of your five current threads

select quarie between houseno ..........

select house_no order

select only up to first '-' only

display order by like 1,2,3,4,5...............plz write quarie

display order by houseno

relate...

Ok, thats a news for me as well. Anyways if is running 1st time and failing on the 2nd then there is some issue.

Whats is your Source type means...