Steven Willis (9/25/2012)

---

Here's another option that moves the string manipulation and identification of NULLs to the SELECT statement instead of using it in a JOIN or WHERE clause where the...

Eugene Elutin (9/25/2012)

---

I don't think...

dwain.c (9/24/2012)

---

Sean Lange (9/24/2012)

---

And of course if the exact rows matter this can get a LOT more challenging because there may be more than 1 pair where the sum is...

How does CHAR(16) suit you?

SELECT

[Start GUID] = d.aguid,

z.[To Character],

[back to GUID] =

CAST(

STUFF(STUFF(STUFF(STUFF(

STUFF(CONVERT(CHAR(34),CONVERT(BINARY(16),z.[To Character],0),1),1,2,'')

,9,0,'-'),14,0,'-'),19,0,'-'),24,0,'-')

AS uniqueidentifier)

FROM (SELECT aguid = newid()) d

CROSS APPLY (SELECT vID = CAST(REPLACE(aguid,'-','') AS...

Abu Dina (9/25/2012)

---

Thanks Chris,

I'm looking at recursive CTEs but I don't think it will work. Well I've been trying for the last couple of hours and it's still not giving...

Abu Dina (9/25/2012)

---

Lynne's solution works if we assume that the retained ID is always the maximum.

But tthe solution doesn't work with the following record set:

drop table dbo.testing

create table dbo.testing...

EdA ROC (9/24/2012)

---

...Paul - Can you give me an example of what you mean by 'break such queries up'? Maybe my example, or something simpler.

I think I mentioned before that...

ChrisM@Work (9/25/2012)

---

t.brown 89142 (9/25/2012)

---

Yes dynamic SQL would seem appropriate.

Basically you create your entire SQL Statement in a string then call EXEC on it.

e.g.

DECLARE @sql Varchar(MAX);

DECLARE @TODAY Varchar(10);

SELECT @TODAY = CONVERT(...

mick burden (9/24/2012)

---

if I have a table with fields which contain common delimited data in them, is there a way I can read them into some kind of temporary table,...

t.brown 89142 (9/25/2012)

---

Yes dynamic SQL would seem appropriate.

Basically you create your entire SQL Statement in a string then call EXEC on it.

e.g.

DECLARE @sql Varchar(MAX);

DECLARE @TODAY Varchar(10);

SELECT @TODAY = CONVERT( VARCHAR(10),GETDATE(),...

Familiarisation? Probably the easiest place to start is the Activity Monitor.

Watch for Recent Expensive Queries and examine them in detail as they come up. Experiment by sorting the columns...

Hi Abu, thank you for the kind mention - I take it that phase of the project is now concluded.

Have a try with this. It works by first selecting retained...

Inline tvf's would get around the cardinality issues Gail mentions. Something like this:

DECLARE @strID int

SELECT ID

FROM Table1

WHERE ID = @strID AND REP = 1

UNION ALL

SELECT ID

FROM...

prasan.dash83 (9/25/2012)

---

I have are a set of create table statements having Select queries with multiple conditions. Some of the conditions include filters for the current date like:

'Create table emp_hrs as...

Duplicate post - please reply to

http://www.sqlservercentral.com/Forums/FindPost1363825.aspx