Can you just not use FOR XML with SELECT statement, and save the output as text file with xml extension?

Before posting your SQL on the forum, pls at least check if it runs correctly, and with this increase your chance getting the question answered.

Going back to the problem,...

Also you shouldn't be using SA account for the application to connect to SQL Server instance, even with very very strong password, create seperated SQL Server login map it to...

Have you installed named instance of SQL Server?

I would use 'Server Explorer' (in VS 2003, View->Server Explorer') and use 'Connect to Database' to create connection to your server. After you...

Each account has a variable number of gift, which will make your resultset to return variable number of columns. I could suggest you following steps:

Logic should be inside stored procedure:

1....

In SQL Server 2005 nonclustered index can contain 'included' columns which are not part of index key, but are added to the leaf level. Index scan would also read...

Hi Terry,

How you can tell that gl_group_id column is a unique key in ipadmin.GL_TXN table?

I agree that your's Northwind example is working fine, but we know that orderid column is...

Your query is not an equivalent to the original one, as the result of subquery is just list of 'gl_group_id' and then you are updating records with these gl_group_id, not...

For tips and tricks on dynamic SQL I would recommend reading 'The Curse and Blessings of Dynamic SQL' article by Erland Sommarskog.

Solution to your problem (the same as suggested by...

Ayie,

You should wrap this T-SQL code into stored procedure, or if you cannot create stored procedures, by using SqlCommand method ExecuteNonQuery you can submit full batch with temporary table...

Hi,

You could consider putting the data from the subquery to temp table

Create table #temp

(

gl_group_id Int

)

insert into #temp

select distinct gl_group_id

from ipadmin.gl_txn

where transacted_on >= convert(datetime, '03/07/2008', 103)

and transacted_on...

In SQL Server 2008 there is a functionality called Resource Governor, and I think this is what you would need to allocate resources appropriately between different sessions.

Resource Governor...

Scanning clustered index on the table consumes the same resources as performing full scan.

However if index is nonclustered, scanning it will read all the index pages, but these are...

What about using left join, so you will get one row for serial number with calculated component type which can be verified against you business rules to get SerialNumberValue.

...

1) Open Enterprise Manager

2) Select Security->Logins

3) Right click on existing and select 'Properties'

4) Select 'Database Access' if you want to grant them database roles or 'Server Roles' if they need...