Viewing 15 posts - 25,621 through 25,635 (of 26,487 total)
You probably need to use dynamic sql in this case. I was looking at BOL, and was curious, what if you try this:
in ((select @isps))
July 27, 2007 at 9:49 am
It would help if you could provide the DDL for your table, some sample data, and what the returned result set should look like.
![]()
July 27, 2007 at 9:06 am
We use the ExecuteProcess Task to FPT files to an MSP using sslftp. I wrote a cmd file that is called in the Execute Process Task that uses a script...
July 27, 2007 at 9:03 am
And it is starting again in a different thread (and no, I'm not getting involved).
![]()
July 26, 2007 at 5:40 pm
You will need to ask your friendly DBA to install the SQL Server 2005 client tools on your box (or where ever it is you need them). If you have...
July 26, 2007 at 3:09 pm
Depends if you are using SQL Server 2000 DTS or SQL Server Integration Services. In the first, you will probably need to use an ActiveX Script task, in the latter...
July 26, 2007 at 12:47 pm
You are going to need to SQL Server 2005 Client tools loaded on the SQL Server 2000 box. To access the SSIS package you need the Busness Intelligence Developer Studio. ...
July 26, 2007 at 12:39 pm
SELECT SUM(A.Invoice), A.InvoiceDate,
CASE
July 26, 2007 at 8:00 am
SELECT SUM(A.Invoice), A.InvoiceDate,
CASE
July 25, 2007 at 3:33 pm
SELECT SUM(A.Invoice), A.InvoiceDate,
CASE
July 25, 2007 at 3:29 pm
My understanding of both SQL Server 2000 and SQL Server 2005 is that if you have an active/passive cluster or primary/mirror (2k5) that you only have to license the active...
July 25, 2007 at 12:47 pm
When working with SQL, you should try thinking in a set-based fashion. Thinking procedurally you will end up with a lot of scripts/stored procedures/et al that probably make a lot...
July 25, 2007 at 8:12 am
First, it looks like you are thinking procedurally. There is no need to loop through anything, nor to actually wait for all the line items to be inserted. Here is...
July 25, 2007 at 7:51 am
Try this: exec sp_refreshview @viewname = 'name of view'
![]()
July 25, 2007 at 7:25 am
Viewing 15 posts - 25,621 through 25,635 (of 26,487 total)