Duplicate post. Reply here.

If you have to retrieve values from a table, rather than simply test for existence, you probably should use a JOIN. Joins and correlated subqueries produce...

In the first instance, it is probably interpreting your constant as a decimal or numeric type.

declare @val decimal (6,2)

set @val = 8493.65

select round(@val,0)

Hey Nick,

CONVERT() gives you more control over the format of the output string than CAST().

You're welcome, Marcus, and much success to you.

Nick, what you are seeing is an example of "parameterized" dynamic SQL. Instead of building the entire string, you can actually pass values into it as parameters....

Nick, here is another article by Gail on the topic of SQL injection, which is a hacking technique used against SQL Servers. I'm including it because you really...

Okay... I see where you are going wrong. You can't just use a variable to build code and stick it in the middle of code like that, unless...

I would like to help but I'm not sure I understand your problem.

What results are you getting currently? Error messages? Null...

I'm gonna Fedex Barry a load of frozen pork chops to throw at you guys for laughing at his pain.

(Although I have heard that schadenfreude is...

Fair questions. Play around with this for a minute and you will see that it works for other dates than today. Explanations follow.

-- edited to...

Guys, I encourage you to give CTEs a try. They act like views which exist only for the duration of a single query. But they read from...

You might also consider a view or cte that casts all your datetime columns as varchar. You realize of course that you can get no benefits from...

Actually, your solution is more commonly referred to as a crosstab, not a pivot.

PIVOT is an SQL keyword in 2005 and up.

Why are...

Does this help ?

--

select getdate() as today

,DATEPART(wk,getdate()) as WeekOfYear

,left(DATEADD(wk,DATEDIFF(wk,0,getdate()),-1),6)+ ' - '

+left(DATEADD(wk,DATEDIFF(wk,0,getdate()),5),6) as weekRange

--