Viewing 15 posts - 361 through 375 (of 1,124 total)
nimdil (4/2/2009)
If it works fine with you - well. Something is unfortunately wrong with my...
April 2, 2009 at 4:27 am
Assuming that you are dumping the csv file to a temp table, you can use Execute SQL outside the DataFlow task and use the NOT EXISTS query to return the...
April 2, 2009 at 4:09 am
nimdil (4/2/2009)
Try to link remote server and do it with[remote_computer].[database].[schema].
instead of
[database].[schema].
It still works fine...
EXECUTE ( 'SELECT COUNT( * ) FROM TestServer.RnD.dbo.trnOrders WHERE OrderID & POWER( -2, 29 )...
April 2, 2009 at 4:07 am
Using Execute SQL Task and mapping the resultset to Package Variable(s)
April 2, 2009 at 3:34 am
This works fine for me...
IF ( OBJECT_ID( 'tempdb..#SomeTable' ) IS NOT NULL )
DROP TABLE #SomeTable
CREATE TABLE #SomeTable
(
SomeColumn1 INT NOT NULL,
SomeColumn2 INT NOT NULL
)
INSERT ...
April 2, 2009 at 3:31 am
Assuming that the long parameter forms a part of a where clause in one of your queries in the procedure, you have first get rid of the single identifier (i.e....
April 2, 2009 at 3:17 am
Kingston (3/7/2009)
Try this. I hope this works..
;WITH cteTable AS
(
SELECT ROW_NUMBER() OVER ( PARTITION BY zipcode ORDER BY datevalue ) AS RowNumber, *
FROM...
April 2, 2009 at 2:49 am
How about providing table scripts, sample data and required output? Don't know how to post, click here to know[/url]
April 2, 2009 at 2:37 am
Are you sure that the Products & ProdFiles tables linked with CategoryID instead of ProductID? I suspect they aren't.
If they are indeed, can you provide the output required for...
April 2, 2009 at 2:35 am
Assuming that you're applying the query on SQL 2005 OLEDB Component, you can use the ranking function "ROW_NUMBER" to order the resultset. For e.g.
; WITH Users
AS
(
SELECT ROW_NUMBER()...
April 2, 2009 at 1:28 am
If you can provide us the required output for the sample you have given, we can provide you with better solution. If you just wanted to filter rows then apply...
April 2, 2009 at 1:14 am
Phil Parkin (4/1/2009)
... and I thought I had tested that! Well, it was early in the morning :doze:Nice approach Ramesh - great use of logic.
Phil
...Sometimes, my mind works well in...
April 2, 2009 at 1:03 am
Phil Parkin (3/31/2009)
declare @a varchar(50), @b-2 varchar(50)Set @a = '01008,03072,0045,R,,,,,,,,,-17'
Set @b-2 = replace(@a, ',,', '')
Phil, this works fine ONLY if the no. of consecutive commas is an odd...
April 1, 2009 at 9:22 am
You are welcome, and I'm glad that I could help you.
April 1, 2009 at 9:20 am
Differences!!!
1. "TRUNCATE" deletes all the records from the table whereas "INSERT INTO" inserts data into the table.
2. "TRUNCATE" requires db_owner or db_ddladmin permissions whereas "INSERT INTO" requires INSERT or db_owner...
April 1, 2009 at 8:23 am
Viewing 15 posts - 361 through 375 (of 1,124 total)