eseosaoregie (6/30/2011)

---

I have a table which lists finance reporting units (RU), buisness units(BU) and there respective consolidation entity (ENT).

Every RU and BU combo is related to more than 1 ENT....

The...

CASE works within a statement, IF chooses...

Jnrstevej (6/29/2011)

---

...So the vendor can only contain a maximum of 7 numeric values i want a statement which counts the number of numeric values of the vendor lets say there's...

Steve, working effectively with TSQL, as with any programming language, requires experimentation...

SELECT 'PL01' + '_' + CASE

WHEN vendor IS NULL THEN SPACE(4)

WHEN LEN(vendor) < 4 THEN CAST(Vendor AS CHAR(4))

WHEN LEN(vendor)...

Good luck!

Can you post the query?

Jeff Moden (5/15/2011)

---

Oh... be careful, Chris. Apologies for quibbling but a Recursive CTE isn't set-based. It's a form of hidden RBAR...

You're welcome - and you have the benefit of a fully-documented method 🙂

lance.kentwell (4/6/2011)

---

Thanks I dont care so much if its elegant, just as long a it works 🙂 I'll give it a try. Since im still a newbie I...

Hello

Read this article [/url]by Jeff Moden to understand how the following code works.

-- make some sample data

SET DATEFORMAT DMY

DROP TABLE #tblMeeting

CREATE TABLE #tblMeeting(

...

This should work just fine although it's far from elegant.

SELECT DISTINCT i.ipaddress, u.user_name

FROM dbo.scr_dim_site_request sr

INNER JOIN dbo.scr_dim_site s

ON sr.site_id = s.site_id

INNER JOIN dbo.scr_fct_exact_access ea

ON sr.site_request_id...

lance.kentwell (4/5/2011)

---

I need to use the result of a query, call it query 1, as a WHERE criteria in query 2. I tried to do it as a subquery...

Golive.

Roy Ernest (4/4/2011)

---

I think then I have to remove quite a bit of target stickers. I think the target sticker is on me... 😀

First they tried to hit me from...