He is perfect also in other solutions as I can see ...!

:hehe::hehe::hehe:

I find it on another way like this but Gila's post is the best for me!?

Select MyColumn FROM

(

SELECT CAST(CAST(0.10*100 AS numeric(10,2)) AS varchar(5)) + '%' as MyColumn

Union

SELECT CAST(CAST(0.011*100 AS...

Gila you are very SQL Sick... very nice solution without adding or removing any other expression!

Nice solution Gila!

Dugi

:w00t:

It is interesting it doesn't work with ROW_NUMBER() function , so how it works on the other way!? :w00t:

Nice info refreshing Intellisense in local cashe!

Thnx GM

:hehe:

VERY EASY;

SELECT ID, CONVERT(VARCHAR, DATE, 103) AS YOURDATE, COUNT(ID_SOMETHING) FROM TABLE

GROUP BY ID, DATE

if you do not have any solution please post the definition of your table and some sample...

VERY EASY ....

SELECT * INTO new_table_name

FROM any_kind_of_your_view

that's it!!!

:hehe::cool:

Ok the ideas are here and if you want to clearly solution you must post the table definition and some sample data just to do the things correct!

no you can not do such a thing... you should save the script for deleting also with parameter that identify the condition and after that you will do schedule the...

nice thing to know!

NICE explanation Gila ...thnx!

:hehe:

till you do not have network conn is very poor system... otherwise I do not have any idea how to do sharing without network conn!!!

:hehe:

Jeff Moden (8/3/2008)

---

That will work just fine, but only if a single row is inserted at a time. If there's a chance that more than 1 row can be...

no SQL Express support till 4 GB for database size!

Maybe many of them... the first one is when you have the large database environment you will do some partition data in many data files so this partition is possible...