I don't want to appear to be rude, but with 2,087 visits on this forum you definitely aware of how to post questions here. If not, link in my signature...

Happy to help, but I wonder what scotsman has to do with RosAviaKosmos ? 😀

Please next time, test your code before posting so its runs without error!

Also, you've created another thread for the same question!

You have very strange requirements, but I leave it with...

If I'm right you want to search for something and replace it in every column in every user table.

Ok, if you really determined, that is for you:-D:

DECLARE @sql NVARCHAR(4000)

DECLARE cupd...

checkai (8/8/2011)

---

I want people in the field to be able to email a mail generic account with a client's ID number as the subject. Then have SQL generate a dataset...

SQLSandwiches (8/17/2011)

---

...

As for commented code, do you guys enforce it in your workplace? I was able to use policy management for object naming but didn't find a way to enforce...

Could you please clarify what you want top be displayed as: a.id a.name b.num

There are no such columns in your sample table setup.

But as general answer: most likely you...

Try to remove everything from the noise file you changed, will you see any effect for other words?

SELECT Col1 AS Column1

,Col2 AS Column2

.....

INTO #t

You can see...

Where?

In Sql Server - Yes, you can. I'm sure you have a high chance that T-SQL will work there 😀

But I'm not sure about Informix... You can try and...

Using temp tables...

How you want your count to be returned then?

Returning the count in the column would be the best option, client app can read this value from first row and then...

Vlad-207446 (8/15/2011)

---

well the issue is not the start date but the end date.

"31/12/2004" is not a valid date in SQL server unless the server default is set to a...

Cadavre (8/16/2011)

---

Is there any problem with just using @@ROWCOUNT ?

DECLARE @RowStart INT

DECLARE @RowEnd INT

SET @RowStart = 1

SET @RowEnd = 100

;WITH CTE AS

(

SELECT *, ROW_NUMBER() OVER(ORDER BY (SELECT...

I wonder what would cause you...