Sorr I had to reformat the query so It could be veiwed easily.

SELECT

vc.charge_id,

vc.service_item_id,

(

Select top 1 sim.description

from services sim

where vc.service_item_lib_id = sim.service_item_lib_id

and vc.service_item_id = sim.service_item_id

),

vc.cpt4_code_id,...

while connected to Integration services under msdb you can right click on the SSIS and export it to a file. you can then right click on the file once...

K I have to ask why should you not use cast or convert?

I think you lost me here. what do you mean there are more...

that about sums it up. I even have a few DB's with what I refer to as a self destruct table.

The best example is a progrma I will not...

I saw something like this once.

What I discovered was what I considered to be lazy programming but basically there was a trigger that fired on upate. The belief was that...

The stuff function can be pretty resource intensive combined with a distinct in the same query this could tak some time if you are dealing with a large number of...

If you could post the Query you are attempting to use that might help us determine what you rproblem is without reinventing the wheel. I am not sure I...

I don't know that you would see much of a performance difference. SSMS is retty light on resources and any Querires they submit are run on the server side regardless...

This is industry behavior as new products come out old products are outdated and roll off of support. Microsoft is currently at SQL Server 2008 and that is the...

I realize that some of the threads may be less than lovely as suggested but If you have spent any time on other boards around the IT community you know...

there is a T-SQL group under the 2005 group.

http://www.sqlservercentral.com/Forums/Forum338-1.aspx

What is your question?

I do not beleive there is a migration tool however if you are just wanting to learn SSIS then Microsoft has some really good tutorials on SSIS with walk through...

Being relatively new to the community I can not claim much responsibility for helping anyone yet but I would like to add that having been in many areas of IT...