Viewing 15 posts - 1 through 15 (of 29 total)
Left outer join returns all records from left table, at same time, it brings all matching rows from right table for the given predicate and NULL appears in right side...
December 30, 2015 at 11:58 pm
ALTER TABLE dbo.MySales ALTER COLUMN orderstatus VARCHAR(20);
OPTION 4 will fail as there is no such column in the table.
December 29, 2015 at 10:00 pm
You can also get this done by using CROSS APPLY.
SELECT * FROM @widgits w CROSS APPLY (SELECT TOP 1 ws.StatusDate, ws.StatusCode
FROM @WidgitStatus ws WHERE ws.WidgitId = w.WidgitId
ORDER...
December 28, 2015 at 5:14 am
You can alternatively use HASHBYTES to find the duplicates.
;WITH hashSet AS
(
SELECT
set_id,
SUM(CAST(HASHBYTES('SHA1',col1+col2+col3+col4) AS BIGINT)) AS uniqueId
FROM @test-2
GROUP BY set_id
)
SELECT * FROM hashSet a...
December 24, 2015 at 12:34 am
if the optimizer generate the new plan during the statement level recompilation, will it remove the old cached plan which is created for the SP?
July 30, 2013 at 1:21 am
Ok, in this case why the cached plan is not updated since the statements were recompiled?
When I compare the current cached plan with previous plan (10 days old) there is...
July 29, 2013 at 5:04 am
[font="Arial"]Yes, this is one time exercise. I planned to go with SSIS package because as per the company policy I should not use linked server approach. There are 129 tables...
July 5, 2013 at 12:56 am
When sp_rename is used to change the name of a table, it just change the name. there is no change to the index, constraints, etc.
BOL:
You need to aware about :...
June 14, 2013 at 7:55 am
It looks like you are missing concatenation
set @midcolumns = @midcolumns + 'colname' + quotename(@intflag + 1, '[') + ' nvarchar(max) null,';
As a separate note, I don't think you can...
June 14, 2013 at 3:37 am
looking at the file name and expression, you are missing variable in your expression
The correct expression should be like this
"c:\\Paychex\\Custom-"+ @[User::variablename] + ".csv"
June 6, 2013 at 6:05 am
Use expression to build the complete file name, if you want to make it more dynamic
June 6, 2013 at 5:55 am
I would recommend you to consider these points to decide where to host your package.
Are you going to run the package in any specific time let’s say once in...
June 6, 2013 at 4:22 am
Viewing 15 posts - 1 through 15 (of 29 total)