ramadesai108 (10/4/2011)

---

As I stated earlier, it works for IN clause, but does not work for an int variable

SET @query = N'

SELECT * from tbl where (nid = '+@ID+')

AND ID IN('+IDs+')'

It...

I understand the concerns about functions from a historical point of view but this is a table valued function and NOT a scalar which is why some shops don't let...

I would recommend NOT doing this in dynamic sql. The example you posted is not dynamic sql. Trust me you want to use the splitter function from Jeff.

Your final query...

Yes like mentioned you cannot perform multiple aggregations on a single column. You can however split this into two pieces in a subquery and perform your calculation outside. Like this.

select...

Note this is a 5 year old thread. 😀

Probably a better way to do this is to use a splitter. Our very own Jeff Moden has a fantastic one here. http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D

The speed you will experience is amazing and...

I think that may be further proof that few people has utilized this...nobody want to speak on a topic that they don't know about. I am hoping I can find...

ROW_NUMBER()

http://msdn.microsoft.com/en-us/library/ms186734%28v=SQL.90%29.aspx

Hi. It seems you are somewhat new around here. Welcome. Before we have a chance at helping you with your issue you need to provide some details. If you want...

jcrawf02 (10/4/2011)

---

That's hilarious, but I doubt that's usually a viable option. Who is really that...

Just to be 100% clear sql does not have a boolean but a bit data type is a decent replacement. A boolean...

If this is a one time thing just run your select in SSMS and select the results to file option. This will let you name the file to whatever. If...

parsayandan (10/3/2011)

---

I ask in past from Google advertise team from content of this site and when he say to a site spammer

he tell me when you use a thing without...

I think it is a language issue more...

parsayandan (10/3/2011)

---

SPAM OR Collect

this is two word with two means

1- If we stole or ... your data , I don't chat with you for this

2- I know different between stole...