Viewing 15 posts - 6,961 through 6,975 (of 7,168 total)
greg.bull (3/10/2011)
By the way, I can't us MERGE, need a SQL2005 solution.
Why did you post this in the SQL2008 forum? Try posting this in the SQL2005 forum.
March 10, 2011 at 12:05 pm
WayneS might be on to something. Is your copy registered?
I just setup wzzip to test locally and here is what I get the first time I try running it:
C:\Program Files\WinZip>WZZIP.EXE...
March 10, 2011 at 12:03 pm
Not that you won't get help here, but you may be better off posting this in an SSRS Forum: http://www.sqlservercentral.com/Forums/Group416.aspx
March 10, 2011 at 11:54 am
Ideally you should have the package use Windows Authentication to reach both SQL Servers and set the ProtectionLevel to DontSaveSensitive.
If that is not an option and you must use a...
March 10, 2011 at 11:31 am
Random thoughts...
Curious, what is @ doing in your command line? This is what I get when I run your code:
"D:\Program Files\Winzip\wzzip.exe" -m \\MyServer\MyShare_dev\Folder1\Processed\Group\Item\Details_201103101058.zip @\\MyServer\MyShare_dev\Folder1\Processed\Group\Item\Details.lst
Just a hunch...try surrounding your file name...
March 10, 2011 at 11:01 am
I guess I had gotten farther than you and missed the issue completely...I thought you were having trouble parsing the XML in the script task. ADO.NET is what I used...glad...
March 10, 2011 at 8:31 am
Are you comparing apples to apples...are:
- both connections from SSMS on the same machine?
- both connections from SSMS but on different machines?
- you using SSMS using instance-name and some web...
March 10, 2011 at 7:22 am
Kiara is on to something with permissions. Also make sure the user executing the statement that is firing the trigger has permissions to TRUNCATE the table.
March 10, 2011 at 7:10 am
That is not a lot of information to provide for a performance problem...there could be a lot of reasons for this type of scenario to arise.
- Are you running it...
March 9, 2011 at 5:09 pm
You have a point...I read more into this part of the requirement
delete count(OrderID )>1 and [City]=null
meaning to me "only delete rows with a NULL City if there is another row...
March 9, 2011 at 5:06 pm
ColdCoffee (3/9/2011)
Or this>
delete from #Tempwhere OrderID IN
(
select T.OrderID
FROM #Temp t
GROUP BY T.OrderID
HAVING (COUNT(*) > 1 AND COUNT(T.OrderID) <> COUNT(T.City))
)
This deletes both rows where OrderID = 111111 which...
March 9, 2011 at 4:54 pm
Here is one way for PK = 1:
WITH cte(element)
AS (SELECT CONVERT(XML, '<root><i>' + REPLACE(beforeImage,...
March 9, 2011 at 4:45 pm
Try this:
WITH cte(OrderID)
AS (SELECT OrderID
...
March 9, 2011 at 4:07 pm
The return type of ENCRYPTBYKEY is varbinary(8000) http://msdn.microsoft.com/en-us/library/ms174361.aspx
You may want to look into doing something homegrown using SQLCLR, or look around for projects on codeplex or sourceforge.
March 9, 2011 at 4:00 pm
Sopheap Suy (3/9/2011)
March 9, 2011 at 2:14 pm
Viewing 15 posts - 6,961 through 6,975 (of 7,168 total)