Viewing 15 posts - 1,126 through 1,140 (of 2,894 total)
A couple of us just went through all of this on another thread a couple of months ago and the LIKE expressions blew the doors off the RegEx CLR.
Could anyone...
October 1, 2012 at 4:37 am
You should really avoid using ntext, text and image datatypes and use nvarchar(max), varchar(max), and varbinary(max) instead http://msdn.microsoft.com/en-us/library/ms187993.aspx. I guess you have old database migrated from previous version of SQL...
October 1, 2012 at 4:05 am
justmohit (9/28/2012)
You can do like this alsoINSERT INTO Tablename( COLUMNName )
VALUES ( 0 ),(1),(2)......(1000)
That is really funny 😀
Do you want a query which will build this kind of statement...
September 28, 2012 at 9:29 am
;with a
as
(
select 1 a
union select 2
union select 3
union select 4
union select 5
union select 6
union select 7
union select 8
union...
September 27, 2012 at 4:35 pm
Could you simply specify a calculation formula?
Some thing like:
[Count Of Distinct Response Choices]/[Number Of Choices] * 100%
I cannot see how you got your numbers of 100% and 50%
September 27, 2012 at 8:19 am
ChrisM@Work (9/27/2012)
Eugene Elutin (9/27/2012)
I have read a spec... 🙂...
Obviously not this OP's spec! The input value is supposedly DECIMAL(5, 4), however this appears to clash with the quoted numbers in...
September 27, 2012 at 7:18 am
sivajii (9/27/2012)
percentage i made by calculating reponse for a question choiceidid depend on this two table
@Response,@Responsechoice
related columns
Response
QuestionId
Choiceid
I do understand that you somehow did calculate it using...
September 27, 2012 at 7:02 am
I have read a spec... 🙂
Now, I cannot see any value in a function which removes decimal point in a way it does.
It's just my guess, but I'm somehow...
September 27, 2012 at 6:12 am
What "percentage" does represent? How it supposed to be calculated?
The rest is here (you need to join just 3 of your tables):
;with agr_calc
as
(
select q.Record, q.QuestionId,...
September 27, 2012 at 3:56 am
SQL Kiwi (9/26/2012)
Eugene Elutin (9/26/2012)
If you work with monetary datatypes you should understand how SQL works with them and when rounding is performed.Are you talking to me?
No! Sorry, I was...
September 26, 2012 at 9:49 am
How are you trying to calculate difference?
Is the Appt Time should be taken as for the same date as one in the column which contains date and time?
What is really...
September 26, 2012 at 8:28 am
...
The ranges of the two types have been discussed already, but there is another consideration:
-- Result is $1.0000 typed as smallmoney
DECLARE @credit smallmoney = $1.99;
SELECT @credit / 10000 * 10000;
GO
--...
September 26, 2012 at 8:20 am
May I ask you to provide a bit more details?
Here you can read tips, which should help to attract relevant answers to your questions:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Please help us to help you!
September 26, 2012 at 6:33 am
farax_x (7/24/2012)
...On the other hand sending UNIQUEIDENTIFIER to customer is not acceptable so I need to convert it to int ...
ChrisM@Work (9/25/2012)
How does CHAR(16) suit you?...
I don't think that CHAR(16)...
September 25, 2012 at 8:58 am
lremovals24 (9/24/2012)
September 25, 2012 at 7:27 am
Viewing 15 posts - 1,126 through 1,140 (of 2,894 total)