Viewing 15 posts - 3,631 through 3,645 (of 8,731 total)
Be aware that an identity column might have gaps, so you might need to create an artificial key.
Something like this:
WITH cteLog AS(
SELECT ROW_NUMBER() OVER(ORDER BY SNum...
December 28, 2015 at 7:38 am
I'm sorry, change the 12 in the where clause to use file month column.
December 22, 2015 at 9:11 am
This will return the data with the current table design. I agree with John on correcting the data types, but I understand that sometimes is not possible. If at all...
December 22, 2015 at 6:44 am
matt.warren 33350 (12/21/2015)
I can't thank you enough for all your help.
I ran into some errors with the code you helped me with, but having seen your advice, it makes...
December 21, 2015 at 5:48 pm
BL0B_EATER (12/21/2015)
Ahhh I wanted to see a light saber! 🙂
It doesn't apply, but lightsabers were banned in some theaters in the US. Others just banned masks and blasters. That's so...
December 21, 2015 at 6:59 am
I wouldn't rate it as high. I felt it was just a mashup of the previous movies. Taking so many elements of the previous movies made it predictable.
I had a...
December 21, 2015 at 6:56 am
Or you could use cross tabs instead of pivot.
DECLARE @sql nvarchar(max),
@Params nvarchar(4000);
SET @Params = N'@VolumeParam int,
@RegStartQtrParam int,
@RegStartYearParam int,
...
December 21, 2015 at 6:49 am
This might be simpler.
SELECT LEFT( trunc.message, CHARINDEX(' ', trunc.message)), *
FROM dbo.sysjobhistory jh
CROSS APPLY( SELECT SUBSTRING( message, 49, 4000)) trunc(message)
December 18, 2015 at 2:26 pm
I'm sorry, I've been busy, but I'll try to explain.
The following code is a common way to create a tally table on the fly. It will generate zero reads, so...
December 18, 2015 at 2:18 pm
eluriraja (12/16/2015)
WHAT TYPE OF QUESTIONS IS THERE CHANCES TO ASK.....?
One question could be:
Tell me about your experience. What did you do on your previous job? What problems did you...
December 17, 2015 at 6:57 am
This is the approach I would take. I wouldn't store this result in a table as this would be a waste of storage. This should be for display purposes only.
-----------------...
December 17, 2015 at 6:53 am
sivaj2k (12/16/2015)
Here is simple way of getting the output....
Regards
Siva 🙂
Only if you can be sure that there won't be any gaps. In the real world, that's unlikely to happen.
December 16, 2015 at 7:04 am
Sergiy (12/13/2015)
Luis Cazares (12/9/2015)
declare @URL varchar(100) = 'http://www.mydomain.info/Customer.aspx?dcc=EUR&h_hmid=2907831&mobiredirect=no&cpn=3790'
SELECT *, LEFT( initial.pos, CHARINDEX( '&', initial.pos + '&') - 1)
FROM (VALUES (@URL)) AS x(url)
CROSS APPLY (SELECT SUBSTRING( x.url, CHARINDEX('h_hmid=',...
December 15, 2015 at 5:43 am
In SQL Server you don't have to enable constraints. They're enabled by default.
December 11, 2015 at 1:57 pm
The code you attached is just creating some tables. The syntax is very similar, remove the double quotes, adjust the data types (varchar2 to varchar, timestamp to datetime, number to...
December 11, 2015 at 1:40 pm
Viewing 15 posts - 3,631 through 3,645 (of 8,731 total)