I'm sorry, change the 12 in the where clause to use file month column.

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...

matt.warren 33350 (12/21/2015)

---

Hello Luis,

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...

It doesn't apply, but lightsabers were banned in some theaters in the US. Others just banned masks and blasters. That's so...

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...

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,

...

This might be simpler.

SELECT LEFT( trunc.message, CHARINDEX(' ', trunc.message)), *

FROM dbo.sysjobhistory jh

CROSS APPLY( SELECT SUBSTRING( message, 49, 4000)) trunc(message)

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...

One question could be:

Tell me about your experience. What did you do on your previous job? What problems did you...

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.

-----------------...

Only if you can be sure that there won't be any gaps. In the real world, that's unlikely to happen.

Sergiy (12/13/2015)

---

Luis Cazares (12/9/2015)

---

This should be safer.

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=',...

In SQL Server you don't have to enable constraints. They're enabled by default.

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...

I'm missing the question here.

What are you expecting? All the records? No records at all? Would you want to wait until user selects the parameters to return the records?