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...
--Ramesh
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...
--Ramesh
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 )...
--Ramesh
April 2, 2009 at 4:07 am
Using Execute SQL Task and mapping the resultset to Package Variable(s)
--Ramesh
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 ...
--Ramesh
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....
--Ramesh
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...
--Ramesh
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]
--Ramesh
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...
--Ramesh
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()...
--Ramesh
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...
--Ramesh
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...
--Ramesh
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...
--Ramesh
April 1, 2009 at 9:22 am
You are welcome, and I'm glad that I could help you.
--Ramesh
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...
--Ramesh
April 1, 2009 at 8:23 am
Viewing 15 posts - 361 through 375 (of 1,124 total)