Viewing 15 posts - 2,401 through 2,415 (of 3,738 total)
Many companies forbid the use of xp_cmdshell.
I have done this using SSIS with a Script task using expressions.
I would share it with you but I do not have access to...
August 21, 2011 at 4:03 pm
I'm sure that you will get more responses and I expect that someone may provide an alternative solution to this issue. š
August 21, 2011 at 3:57 pm
BuntyBoy (8/21/2011)
August 21, 2011 at 3:45 pm
Sounds like a fun project.
I would probably write a program that sequentially processing one file at a time.
You could create a table that has a column to set the process...
August 21, 2011 at 3:34 pm
I probably should have not mentioned salary because it is not relevant to the situation. I meant in the context that I do not know much other than the pay...
August 21, 2011 at 3:23 pm
I would start out by creating the objects, code, etc in the development environment.
Try simulating on a smaller scale the intended scenario on the production environment.
Then as you move to...
August 21, 2011 at 2:56 pm
sqlheadquarters (8/21/2011)
[Thank you for the great advice. I did however say I was taking the excel certification, not the PowerPoint. Excel is a very good skill to know if I'm...
August 21, 2011 at 2:46 pm
You don't need to create 1,000 tables.
If you create a staging table then you can minimize the impact on performance.
You could create a job to load the data from the...
August 21, 2011 at 2:27 pm
sqlheadquarters (8/21/2011)
August 21, 2011 at 2:15 pm
sqlnew (8/20/2011)
Forget about table and Consider some fixed values for IpMin and IPMax just like above mentioned example..if it works i can work for a table. Thanks for responding.
I understand...
August 20, 2011 at 11:49 pm
So far you have only provided one table with two columns and two IP Addresses.
Thank you for the information but don't you have another table?
What does your statement that provided...
August 20, 2011 at 11:41 pm
sqlnew (8/20/2011)
i want to compare an ip whether it is in the range(in max and Min range) or not ..How can...
August 20, 2011 at 11:33 pm
I should have caught that, it is getting late.
You are trying to create a FK Constraint on a child tabe record(s) where there is not a correspnding record in the...
August 20, 2011 at 11:11 pm
john-902052 (8/20/2011)
I have a question if you wouldn't mind.
I have a db Cases with an Identity column CaseID and I have a few other dbs that store the CaseID....
August 20, 2011 at 10:52 pm
Viewing 15 posts - 2,401 through 2,415 (of 3,738 total)