Viewing 15 posts - 9,796 through 9,810 (of 13,879 total)
Can you just put the PKs of the main table to be deleted in the temp table, then index it, then join on that.
Also, you need to surround your deletes...
June 24, 2013 at 1:55 am
If you search your input file for the text 2314K, it should point you in the right direction.
It looks like whichever column that data is in is mapped to an...
June 23, 2013 at 10:43 pm
sagar.gadwe (6/21/2013)
How to convert binary file to text file in ssis package and i want to load it into the table.
As far as I know, binary files would make no...
June 21, 2013 at 7:54 am
Well, if I were you I would suggest it, so that when the pain of maintaining your IDENTITY solution becomes too much to bear, you can always be the smart...
June 21, 2013 at 7:40 am
No doubt it's too late to change this, but have you thought about using NewId rather than identity as your (nonclustered) PK in the various tables?
As far as I...
June 21, 2013 at 6:44 am
Attached excel file? This sounds like homework or someone at the office asking for a very odd request.
The attached Excel file appears to have become detached.
June 21, 2013 at 12:27 am
You need to find out which row it is - possibly by exporting the imported table to Excel and then doing some sort of VLOOKUP comparison - and then work...
June 21, 2013 at 12:22 am
William Plourde (6/20/2013)
Phil Parkin (6/20/2013)
June 20, 2013 at 7:22 am
June 20, 2013 at 5:25 am
How do you intend to use this function? Have you considered writing it as a stored procedure instead?
June 20, 2013 at 12:38 am
Also, this sounds like it might be a task for SSIS - have you considered that as an alternative?
June 20, 2013 at 12:35 am
I would suggest that you need to change the design of the target database so that you do not have identity columns as PKs there. Just make them standard INT...
June 20, 2013 at 12:33 am
I've just skimmed this thread so apologies if this is not what you're looking for. But why not adjust the WHERE clause as follows:
where SomeVal2 = 'ABC' or SomeVal is...
June 20, 2013 at 12:26 am
gissah (6/19/2013)
Thank you sir, All I want to do is just populate the [BusinessDay] column on my table sequentially(1234...) if a day qualify as a business day or workday(MTWTF). Thanks
What...
June 19, 2013 at 10:43 am
We clearly operate in very different environments, as I stick by my comments too - glad that I gave you a laugh 🙂
June 19, 2013 at 8:18 am
Viewing 15 posts - 9,796 through 9,810 (of 13,879 total)