drew.allen (8/2/2009)

---

If all...

Yes, it does....

jcrawf02 (7/28/2009)

---

GilaMonster (7/27/2009)

---

Gaby A. (7/27/2009)

---

arthykannan (7/6/2009)

---

You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and...

There's also an issue when column names contain spaces, the stored procedure parameter names will also have the space in them and causes a syntax error.

Eg. Where a table...

GilaMonster (7/27/2009)

---

Gaby A. (7/27/2009)

---

arthykannan (7/6/2009)

---

You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and the...

...twice !! dozy ******

Sorry, did the same as Jeff, didn't read Andrews answer and posted the same solution. :hehe:

Absolutely !!! Downright stupid 😉

An alternative is to set the foreign key in the child table to NULL before deleting the parent.

In Gails example this would mean adding the following just before deleting the...

This can (and should) be done without having to resort to a WHILE loop.

See Jeff Moden's article here[/url] to see how and why.

Someone else on my wavelength.:-)

I would advise strongly against using a UDF with a WHILE loop in it.

Please see Jeff's article[/url] on using a Tally table to avoid loops.

Read Jeff Moden's article on Tally tables here: http://www.sqlservercentral.com/articles/T-SQL/62867/

Create one, then try this:

declare @t table(date datetime,e int)

insert @t(date,e)

select '20080101',2 union

select '20080105', 3 union

select '20080210', 4 union

select '20080801', 4 union

select...

You should be able to use the web service since it's language independent.

Try : http://www.letmegooglethatforyou.com?q=ssrs+web+service+java

Have a look at this article http://www.sqlteam.com/article/exporting-data-programatically-with-bcp-and-xp_cmdshell