Elliott Whitlow (4/26/2012)

---

I can't under ANY circumstances endorse an sp_OA method to doing this. As a matter of fact I'm of the opinion that those should not be used...

Also as far as Scope_Identity() or @@Identity use is concerned you might also want to take a look at this:

http://support.microsoft.com/kb/2019779

Ed-586976 (4/26/2012)

---

Hi all,

I downloaded SQL Server 2008 R2 from the Microsoft site and I could not see BIDS in it. Can you guys send me the download link of SQL...

slunt01 (4/26/2012)

---

ok I was able to import one table!!!! awesome!:-D it shows up in the manager studio db and everything!

Now the only thing is how do I import more like...

Robin Sasson (4/26/2012)

---

Lynn Pettis (4/26/2012)

---

The bottom line is this, you can't use dynamic sql in a function. Your...

Cadavre (4/26/2012)

---

brally123 (4/26/2012)

---

WOW!!! i'm just amazed on how you guys do this! Thank you so much!

That was fantastic!

Buuuut, I'm sorry I forgot to add this:

foreach distinct COND in tbl_2, i...

I think we've gone back and forth over this a few times.

Can you tell us exactly what it is...

weiwei_huang (4/25/2012)

---

Hello,

I am new to SSIS. I hope someone can help me and provide SSIS solution for the following requirements:

I need to loop through the following table each month to...

I can't really...

poornipmca (4/23/2012)

---

Thank u Robin

I cant use if else statement because there will be a dynamic database creation

and i need acess the function using dynamic sql statement or alternative...

Now, now guys, play nice... clearly the man is in way over his head here!

To the OP, judging by the responses you have posted here, I think you have one...

Yep. I learnt that one yesterday 😛

Or you could just download a trial third party utility that should be able to to do the dependency analysis for you 🙂

I think ApexSql and Redgate have utilities that...

These are problems that are probably best addressed during the initial design of a database.

If you find yourself doing a lot of this then it can be an indicator that...

Robin Sasson (4/20/2012)

---

I'd suggest wrapping the column names in COALESCE in the event of a NULL value.

Select LTRIM(COALESCE(FirstName,'') + ' (' + COALESCE(LastName,'') + ')') AS FullName From MyTable

Check your...