Viewing 15 posts - 661 through 675 (of 789 total)
SMAZ (8/26/2008)
Thanks Gail!Its perfect.
He is perfect also in other solutions as I can see ...!
:hehe::hehe::hehe:
August 26, 2008 at 6:04 am
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...
August 26, 2008 at 5:51 am
Gila you are very SQL Sick... very nice solution without adding or removing any other expression!
Nice solution Gila!
Dugi
:w00t:
August 26, 2008 at 5:46 am
It is interesting it doesn't work with ROW_NUMBER() function , so how it works on the other way!? :w00t:
August 26, 2008 at 5:11 am
Nice info refreshing Intellisense in local cashe!
Thnx GM
:hehe:
August 26, 2008 at 5:09 am
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...
August 25, 2008 at 2:13 am
VERY EASY ....
SELECT * INTO new_table_name
FROM any_kind_of_your_view
that's it!!!
:hehe::cool:
August 20, 2008 at 3:19 pm
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!
August 20, 2008 at 5:08 am
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...
August 20, 2008 at 4:42 am
nice thing to know!
August 19, 2008 at 4:04 pm
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:
August 12, 2008 at 7:41 am
Jeff Moden (8/3/2008)
August 3, 2008 at 10:12 am
no SQL Express support till 4 GB for database size!
July 31, 2008 at 6:00 am
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...
July 31, 2008 at 5:00 am
Viewing 15 posts - 661 through 675 (of 789 total)