It's okay, no need of apologies after all we are...

Mayank Khatri (5/27/2009)

---

Hi Ramesh, I was trying to learn effectiveness from your well written query, In ur query you have been sorting all "Preference" categories by Ascending, but in original...

If it is that kind of urgency, try this link http://lmgtfy.com/?q=export+query+results+to+excel+file+in+sql+server+2005+using+T-SQL

I am wondering;-) why this post is exactly the same as this one

I am not sure what you tried to do here but technically you cannot declare and set variable values in that fashion. Otherwise, you can use table variables to...

I am not sure whether it's a prerequisite or not but I can use the excel connection managers on my server without any problems.

Well, the error means that the application is trying to insert no value or null value into the column "Topic_ID" which seems to be a non-nullable column in the table....

You can use sp_tables_ex procedure to execute distributed queries or use system objects like "INFORMATION_SCHEMA.TABLES" or "sys.objects" in conjunction with "sys.schemas".

Here are few ways of doing it.

SELECT*

FROMOPENQUERY( TestServer, 'SELECT TABLE_NAME,...

The problem is with the table qualifier used in the ON Clause for column "Employee Number".

.....

FROM HRSELECTDB.selecthr.dbo.[Employee Master Table Data] AS [Employee Master Table Data_1] INNER JOIN

dbo.Employees ON dbo.[Employees Master...

Using ROUND function...

SELECT CONVERT( NUMERIC(18,2), ROUND(1245.65879, 2, 1) )

Gianluca Sartori (5/20/2009)

---

Other cases with the same test data:

Divide by zero error:

select *

from @tmpTab

where (column1/column2 = 1)

OR column1 = column1

No error thrown:

select *

from @tmpTab

where (column1/column2 = 1)

...

I follow the same as Gail mentioned except that I take out the first letter from each word from the song name + artist name from a list of my...

First of all, for all your future posts read this article on how to post questions to getter better responses[/url]

Secondly, thanks arjun for preparing sample data and the scripts

Lastly, here...

Mark Fyffe (5/19/2009)

---

|John |,|Doe |,| ...

To publish a report from VS or BIDS to a report server, go to project properties > Set the "TargetReportFolder" & "TargetServerURL" in "Deployment" properties.

Examples:

TargetServerURL = http://MyReportServer/ReportServer

TargetReportFolder = http://MyReportServer/ReportServer/devCRM

To view...