choke the..... oh wait

chew

ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are more out there) ...

a udf is a user defined function. by deffinition to change or update a FUNCTION you have to update or change the code for the function. im starting...

ok so help us help you work within...

we do a similar process, we backup the database, zip it to condense it a little (we dont use backup compression) copy the zip file over the network, unzip the...

ALTER FUNCTION udf... ??

can you post your UDF code and DDL (Create table scripts) and sample data (INSERT Statements) so we can see what gets passed to the udf what...

Sean Lange (4/13/2012)

---

Wow your first post and you posted all the ddl and sample data perfectly!!! Excellent!!! I wish everyone who posted paid as much attention.

Now for your issue. I...

can you post your DDL (create table scripts) and Sample data as text in the thread. that will help every one help you.

vinu512 (4/12/2012)

---

You are right capn.

I tried the Sum(TotalCount), but somehow it was not returning what I wanted. Maybe something wrong I had written in the code. That's when I added...

F.L (4/12/2012)

---

Hello,

Hijacking this thread since OP seems to be satisfied with the solution provided. (I hope that is OK)

I´m trying to use CTE to find the very top parent within...

you have been asked and asked. if you cant read the link in my signature for how we like to see the sample data and table scripts after being...

can you post the create table statements (DDL) and sample data so we know what we are working on. with out the table structure and sample data we are...

Revenant (4/12/2012)

---

SQLRNNR (4/12/2012)

---

Koen Verbeeck (4/12/2012)

---

GilaMonster (4/12/2012)

---

I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing code...

its what i...

sgmunson (4/12/2012)

---

The gremlins are everywhere....

Sadly, the problem is fixed because somebody fat-fingered a table name in existing code and after OBFUSCATING it for publication here, I could no longer tell...