I'm confused.

Were you able to call your GetMonthDays procedure but you want to use procedures to call data from SQL? If that's the case, it would be the same...

If I understood correctly, this should help you:

CREATE TABLE #Source(

SomeString varchar(8000))

CREATE TABLE #Test(

[STD_SiteName] [varchar](20) NULL,

[STD_Parameter] [varchar](16) NULL,

[STD_Qualifier] [varchar](6) NULL,

[STD_PQ] AS (([STD_Parameter]+'_')+[STD_Qualifier])...

This is what I get in the Predicate for each SELECT statement.

SELECT *

FROM bitTest

WHERE somebit = 1

--[Test].[dbo].[bitTest].[somebit]=[@1]

SELECT *

FROM bitTest

WHERE somebit = 'True'

--[Test].[dbo].[bitTest].[somebit]=CONVERT_IMPLICIT(bit,[@1],0)

SELECT *

FROM bitTest

WHERE somebit = 112

--[Test].[dbo].[bitTest].[somebit]=[@1]

--No results

I'm working here as most of the people in my office. Except for my boss who said he was sick and now I have to fix all the problems he...

I just made a test and it doesn't seem to be an implicit conversion when using 1 or 0. It's different when you use 'true'.

CREATE TABLE bitTest(

...

Nice question, I checked the answer just to be sure and realized that a nice wrong answer would have been June 6, 2079 which is the limit for smalldatetime. Mostly...

No, way!

Go Ravens!

Ravens Nation 😀

Yes, it's possible, but I wouldn't advice on using decimals on calculations as it's easy to get it wrong.

For example, .01 translates into 864 seconds instead of 900 seconds. To...

Could you create filtered views and give permissions over those views?

I'm not sure how you're handling your security.

Of course, buying new hardware can get you some time. But how much time would you get if your app is full of crappy code? There's no piece of hardware...

Happy Holidays to everyone!

I wish that you can enjoy quality time with your families and beloved ones and may the new year bring you happiness and growth (hopefully not in...

You can't use variables to replace object names. That goes for DDL, DML, DCL or anything in T-SQL.

You could use dynamic SQL for this.

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now....

Smile, you're on Candid Camera. 😀

g.britton (12/23/2014)

---

The problem with the fourth option is that the nested query needs to be in parentheses. So this works:

SELECT SUBSTRING( ( SELECT ', ' + productname...