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...

Buddy, small tweaks in the code will get you there!

For this requirement,

The SELECT statement for the INSERT should return these records:

A,5

C,1

These are the records in #ListUpdate that are not in...

Wonderful question and equally wonderful explanation. The basics is hit in the nail! Thanks for this!

Hey there! I have coded an below-par code for this requirement! This is what that struck my mind! Pro'ly there are many altenative super-fast , minimal-code, optimal-performance code available....