Viewing 15 posts - 661 through 675 (of 2,894 total)
prakashr.r7 (3/4/2013)
Eugene Elutin (3/4/2013)
http://www.sqlservercentral.com/Forums/Topic1267659-391-2.aspx
That one will generate unique values and it will "automatically" determine the size required based on...
March 4, 2013 at 8:39 am
if you want unique values then use 36-base encoding function from here:
http://www.sqlservercentral.com/Forums/Topic1267659-391-2.aspx
That one will generate unique values and it will "automatically" determine the size required based on how many numbers...
March 4, 2013 at 8:19 am
You can do it using user defined function with a help from small view which makes NEWID() safe for use in UDF's:
CREATE VIEW dbo.UDFSafeNewIDBase AS SELECT NEWID() as SafeNewId
GO
-- will...
March 4, 2013 at 7:37 am
vahid.arr (3/4/2013)
2- if our select has...
March 4, 2013 at 6:56 am
You didn't specified how exactly these "5 phone numbers" are given to you and didn't specified how you want to return the result. Based on you description looks like you...
March 4, 2013 at 3:46 am
with such minimum details...
select id
,max(case when custom_id= 98 then comments else null end) As CEO_Comments
,max(case...
March 4, 2013 at 3:21 am
vahid.arr (3/4/2013)
i get confused where to use function , store procedure and view.plz help me😉
What do you mean by "confused"? What exactly troubles you?
View - it's kind of virtual...
March 4, 2013 at 3:14 am
Ough!
Gentlemen, no needs to argue so much on this subject. I guess everyone involved in this discussion is right on some points. 1900 is definitely more recognisable than 22800,...
March 4, 2013 at 1:59 am
or use PIVOT
select CourseID, [Q1], [Q2], [Q3], [Q4]
from #x2 p
pivot (count(ScheduleTerms) FOR ScheduleTerms IN ([Q1],[Q2],[Q3],[Q4])) pvt
BTW, Cross-tab based on WHEN is usually faster...
March 1, 2013 at 9:42 am
...
I guess I'll have to retest on that. In multiple different threads, Michael and Peter showed that controlling the order of execution within the formula with parenthesis performed worse...
March 1, 2013 at 9:14 am
salmita (3/1/2013)
I just understand my need actually,
I have 6 lists in Sharepoint that depend on another list
and i wanna know how can i do a join between...
March 1, 2013 at 8:46 am
...
He wants his original SQL statement to complete, but I'm not sure that's possible once you've encountered a constraint error. A relational transaction is, by definition, "all or none":...
March 1, 2013 at 3:48 am
replace:
NULLIF(Result,1)
with:
CASE WHEN Result = 2 THEN Result ELSE NULL END
March 1, 2013 at 3:37 am
This cut down number of CPU cycles when performing multiplication as it takes less number of bit-moves for multiplying smaller numbers - I should accept that it's hard to measure...
February 28, 2013 at 10:52 am
Another version with use of dynamic SQL produces required output:
SET NOCOUNT ON;
-- setup sample table
SELECT ID, NAME
INTO #testEnvironment
FROM (VALUES(1,'a'),(1,'b'),(1,'c'),(1,'d'),(2,'e'),(2,'f'),
...
February 28, 2013 at 10:31 am
Viewing 15 posts - 661 through 675 (of 2,894 total)