Viewing 15 posts - 466 through 480 (of 2,007 total)
I'll check when I get back from lunch. My gut feeling is that mine will be heavier on reads whilst yours is heavier on scans.
Not a clue about which...
October 12, 2012 at 6:31 am
Same as the last post I made, still on lunch and waiting in the car so this is untested and written on my phone. Forgive any syntax errors.
Here are two...
October 12, 2012 at 6:26 am
I'm on my lunch waiting in the car for something, so this is untested and coded together using the text editor on my phone.
Would this work for you?
WITH...
October 12, 2012 at 6:06 am
I'm sorry Howard, I completely missed this.
You're correct that so long as the convert is wrapped around the scalar value it doesn't make a huge difference. It does make a...
October 12, 2012 at 2:51 am
Skanda (10/12/2012)
Am having a batch_id in table1, based on batch_id having 10 records in table2.
i.e. batch_id is same for 10 records in table2.
Table2 columns names
Record_id | ...
October 12, 2012 at 2:20 am
asranantha (10/11/2012)
device type(android,blackbery)
1)it is location flagged ,it is international,its rooming
how to create stored procedure by taking input...
October 11, 2012 at 9:39 am
asranantha (10/11/2012)
device type(android,blackbery)
1)it is location flagged ,it is international,its rooming
how to create stored procedure by taking input...
October 11, 2012 at 9:34 am
asranantha (10/11/2012)
device type(android,blackbery)
1)it is location flagged ,it is international,its rooming
how to create stored procedure by taking input...
October 11, 2012 at 9:33 am
asranantha (10/11/2012)
device type(android,blackbery)
1)it is location flagged ,it is international,its rooming
how to create stored procedure by taking input...
October 11, 2012 at 9:33 am
asranantha (10/11/2012)
device type(android,blackbery)
1)it is location flagged ,it is international,its rooming
how to create stored procedure by taking input...
October 11, 2012 at 9:33 am
asranantha (10/11/2012)
device type(android,blackbery)
1)it is location flagged ,it is international,its rooming
how to create stored procedure by taking input...
October 11, 2012 at 9:33 am
Yet another way : -
WITH CTE ([Level],IDs,Name) AS (
SELECT TOP 1 0, ID, CAST(FirstName AS NVARCHAR(4000))
FROM #temp
ORDER BY ID
UNION ALL
SELECT [Level] + 2, ID, CAST(Name+FirstName AS NVARCHAR(4000))
FROM #temp
INNER JOIN...
October 9, 2012 at 8:18 am
Skanda (10/8/2012)
Thank U Boss,It is looking great...
but i need every record should have a numeric and alpabet,
in present code, some records are only alphabetic....
In your original post, you said: -
Skanda...
October 8, 2012 at 6:43 am
Skanda (10/8/2012)
i need same output in sql.....
with digits as
( select n, chr(mod(n,36)+case when mod(n,36) < 10 then 48 else 55 end) d
from (Select...
October 8, 2012 at 6:09 am
Skanda (10/8/2012)
not exactly like home work, as per my requirement only am posting.
i've tried below code, but it is generating only number.
WITH Sequence ( SeqNo) as
(
...
October 8, 2012 at 6:05 am
Viewing 15 posts - 466 through 480 (of 2,007 total)