Viewing 15 posts - 241 through 255 (of 402 total)
Does this help?
SELECT *
FROM
#myTableA AS TA
LEFT JOIN(SELECT
*
,ROW_NUMBER() OVER (PARTITION BY ChecklistStepID ORDER BY EndTime DESC) AS RowNum
...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 9, 2012 at 8:58 am
Hi
Without DDL's and sample data it is very difficult to help - could you post these?
The first thing that springs to mind is using a CTE to create a UNIONed...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 9, 2012 at 7:54 am
As Anthony said if you provide DDL's ect you will get much better answers
I'll take a shot in the dark, maybe this will help you or put you on the...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 9, 2012 at 7:39 am
GilaMonster (5/3/2012)
Because the whole point of cross apply it to allow the passing of a column from another table to a function or subquery.
I've used CROSS APPLY many times in...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 3, 2012 at 7:40 am
Gail thank-you, explained so well even I can understand it 😉
I've been using T-SQL/ P-SQL for years and am by no means a beginner, although compared to some of you...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 3, 2012 at 7:16 am
Thanks both
Eugene yep I knew what it was doing it was more a question of is this expected behaviour.
OK dumb question then if all that is needed is to bind...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 3, 2012 at 6:38 am
It's not an execution time error, it's a parse-time error. The parser doesn't execute the IF statements, it doesn't evaluate (or care) which branch the query will run, it just...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 3, 2012 at 3:06 am
Two options spring to mind
As your using an IF you obviously only want one query to be executed
DROP Table #TempProduction before the next IF is evaluated then create it in...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 3, 2012 at 2:35 am
Thanks Anthony - I'll order a copy
I'll probably need a few more books as well then based on your comments, my main role is Data Warehousing and SSRS but recently...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 3, 2012 at 2:31 am
Glad it helped 🙂
Delete src
From Person.Contact src
Join StageDeletes stage
On stage.Email = src.EmailAddress
Just be careful doing something like this - using the email address to identify new records wasn't the best...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 3, 2012 at 2:05 am
Hi Anthony
Good luck with the exam!
Quick question I'm looking at doing the 70-432 and have looked at buying the MCTS 70-432 self study book but have read very mixed reviews.
What...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 2, 2012 at 9:44 am
bala2 (5/2/2012)
Thanks for help,I was able to connect the package.
Can you please tell me where have to change or modify the column size.
can you plz guide me the steps
Many THANKS.
You...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 2, 2012 at 9:31 am
Pihu.awasthi (5/2/2012)
Can you please tell me how to do the deltas??
To all intents and purposes its an incremental load, only loading records that have changed or been loaded since your...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 2, 2012 at 9:24 am
Does seem a bit long...
Are the destination tables heavily indexed?
Are there no transformations in the ETL?
Could you post the SQL?
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 2, 2012 at 8:11 am
Hi a couple of questions:
Define a bit long?
How large are the tables?
Are you using complex queries to retrieve your datasets?
How many transformations are you performing in your ETL's?
Are you using...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 2, 2012 at 7:58 am
Viewing 15 posts - 241 through 255 (of 402 total)