Wow, good that you learned more abt CTE from that code. Am very happy! :blush:

I just tried query to...

You're Welcome, clucasi! Glad that my code helped you!

This query has to work on other tables as well ie

Street Descriptortype 15 when id(15), Street record-Type11 when...

riyaz.mohammed (5/6/2010)

---

Hi that worked great for the example i provided. If i add another requirement into the mix what would the SQL look like?

SEQUENCE,PRODUCT,TIME,PRICE

1,Spoon1,2010-05-05 08:30:00.000,83.50

2,Spoon1,2010-05-05 08:31:01.000,80.00

3,Spoon1,2010-05-05 08:32:02.000,81.00

4,Spoon1,2010-05-05 08:33:03.000,82.00

5,Fork1,2010-05-05 08:31:01.00,90.50

6,Fork1,2010-05-05...

Hi there, can you please provide us how your desired output will look like. i have actually coded a piece for you, but i want to confirm it with your...

Thanks for the reply, jdddd2! But i need a T-SQL code, as in Ron's example to perform my task!

Anyways, thanks for the info!

Bhuvnesh (5/6/2010)

---

ColdCoffee (5/6/2010)

---

NOTE: This uses the CURSOR method, and i am pretty sure there are many efficient methods to do this. And i smell the no-c.u.r.s.o.r-ever camp is just around...

Hi there, this will do the trick for you!

First lets set up the environment to work on by providing the sample data and the DDLs

IF OBJECT_ID('TEMPDB..#PRODUCTS') IS NOT NULL

DROP TABLE...

I don't exactly understand your requirement, but based on your CASE statement in the first post and some bits-and-pieces i understood from other posts, i have coded one query here....

Welcome, Henri!! 🙂

Try this Henri!

DECLARE @SQLString nvarchar(500);

DECLARE @ParmDefinition nvarchar(500);

DECLARE @Count varchar(30);

DECLARE @server VARCHAR(128)

SET @server = 'dev-server'

SET @SQLString = N'SELECT @CountOUT = count(name) FROM OPENDATASOURCE(''SQLNCLI'',

...

Oh Ron, thanks! I always had a doubt that this has something to with the ODBC drivers.And you have now confirmed it!

Thanks for your efforts and time, Ron!

This must be done in 2 phases (i mean, 2 different queries)!

1. Find out the entries that have "I", use LEFT JOIN and insert them into your target table.

2. For...

You can use this following code to get the details you asked for:

SELECT * FROM dbo.SYSFILES F

LEFT JOIN SYS.FILEGROUPS FG

ON F.GROUPID = FG.DATA_SPACE_ID

Cheers!!

Mark, excellent solution!...

I think i might get you what you want, but i need to see a visual representation of what your end result would be.

Desired results in the form of something...