Right click on a DB table - All tasks - Export data, then follow the wizard to export the data to excel. Save this as a DTS package and view...

You can explicitly create the temp table before opening the cursor (create table #abcs person_last_name ....). Then insert into it like:-

insert into #abcs

SELECT Person.person_last_name, Person.person_first_name, Person.prspct_id, Prspct.hsehold_addr1_name

INTO #abcs

FROM Person JOIN...

Remove the GO command after OPEN name_cursor

as this denotes the end of batch of tsql statements.

Regards,

Andy Jones

andyj93@hotmail.com

This also worked fine for me and restored correctly. My transaction log backups for database 'a' were given filenames containing a date and time stamp e.g. a_tlog_200206271125.TRN this gives you...

isqlw -S "Server name" -d "Database" -U "User" -P "Password" -i "Script 1" -o "Output script 1"

isqlw -S "Server name" -d "Database" -U "User" -P "Password" -i "Script 2" -o...

This is also the way I have done things. We have a form with 7 check boxes for days of the week, the user can

check any combination and this can...

Look at

IF UPDATE (Column)

syntax in the CREATE TRIGGER section in BOL.

Regards,

Andy Jones

andyj93@hotmail.com

You are using numeric(18,0) for the conversion so does the field hold only integers (no decimals)? If so then you could try converting to an int datatype instead. In a...

Sorry for the delay...It's SQL2K Standard with SP1.

I want a user to be able to execute certain procedures which execute master..xp_CmdShell but not master..xp_CmdShell itself, so I ran

the following.

--Add the...

You can add a dynamic properties task to your package, click add, then source your connection from an ini file or global variable (plus other options).

Regards,

Andy Jones

andyj93@hotmail.com

Edited by - andyj93...

select *

from

Ticket ti

inner join Thread th on ti.TicketID = th.TicketID

where

th.Thread_Date = (select max(Thread_Date) from Thread where TicketID = ti.TicketID)

Regards,

Andy Jones

andyj93@hotmail.com

Run a trace on your db using SQL Profiler then create a scipt of your table using EM and view the commands executed in profiler to see where the data...

select newsid,newscat,count(newscat) from table where logdate between '18/06/02' and '19/06/02' group by newsid,newscat

This is between 18/06/02 00:00 and 19/06/02 00:00

Regards,

Andy Jones

andyj93@hotmail.com

Thanks for the response. I thought this was how it should work but in the case you outlined below I am still getting permission denied on sp ip_B??? It works...

Is the total count for information purposes (i.e. this could be calculated before the data is copied) or for veification that

the correct amount of data was copied (i.e. this would...