Thanks Steve.

Maybe see if they can add author to...

Can you post the c# code that does the conversion?

You are welcome. Hope that helps get you going.

See if something like this will get you started. Please notice how I posted ddl and sample data in a consumable format.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

Ticket...

This is another regular expression. This basically is saying give me all the rows where the value is not...

DataAnalyst011 (6/27/2013)

---

From time to time I need to check if a column is completely numeric (or usually, check for the row contain something other than numeric). I've read the ISNUMERIC...

Barkingdog (6/27/2013)

---

I had never heard of a "triangular" join but I verified it is incredibly slow. . (I actually took the very data involved, exported it to a CSV...

IIRC =* is a right join, not a left join. *= is a left join.

SELECT A.recid,

A.id,

A.PROCID,

A.pstatus,

B.pname,

B.pdesc,

LEN(pname) AS plen,

CASE WHEN C.seq IS NULL THEN 0 ELSE 1 END AS DISABLED

FROM lprocs...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1468108-2796-1.aspx

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1468108-2796-1.aspx

You really should at least test the sample data and such when you post it. What you posted was not really consumable. I modified all your inserts that they will...

And here is an example of doing this without using a recursive cte for counting. This code also will only return data for the specified month even if the @StartDate...

Not sure that it is more involved than a cursor. It is a different mindset than...

sivaj2k (6/27/2013)

---

Hi, Please check the following code .

declare @table table (id int identity(1,1),item varchar(10),amt int)

insert into @table values (1,100),(2,200),(3,300),(4,400)

declare @sumtotal int

select @sumtotal = SUM(amt) from @table

SELECT a.id, a.amt,@sumtotal-SUM(b.amt)

FROM ...