Viewing 15 posts - 1,126 through 1,140 (of 4,820 total)
June 7, 2018 at 2:36 pm
I'm doubtful that Chrome will ever react appropriately to SSRS. I don't normally use Chrome for anything that I'm not forced to (e.g. my current work laptop), and never use...
June 7, 2018 at 11:55 am
Think about the business process for this. How on earth can you expect to edit detail records for a master row that doesn't even exist yet? Just converting your Access...
June 7, 2018 at 11:44 am
SQLPain - Thursday, June 7, 2018 10:57 AMAny thought anyone?
How did it get compressed when it was inserted? If you are looking...
June 7, 2018 at 11:29 am
Then be more specific about the table and column that you are trying to insert the value into. I need to know the data type of the column involved. I...
June 7, 2018 at 11:23 am
You'll have to derive a row number for this purpose. You can do so by adding a Script Task to your data flow, and you'll need a package variable to...
June 7, 2018 at 11:20 am
Can you please provide the actual INSERT statement along with the table create statement for the table involved?
June 7, 2018 at 11:14 am
The only way I know of to do that is to recompile the code in Visual Studio, having edited the .Net version to 4.0. Of course, you'll have to actually...
June 7, 2018 at 11:11 am
You'll need to be a lot more specific. What machine(s?) receive the error? What is the ODBC connection supposed to connect to, and from where? What's the purpose of...
June 7, 2018 at 11:03 am
June 7, 2018 at 10:28 am
I had to do this once, and it's not all that easy. The first thing is to recognize that you are also going to need to recognize holidays, and without...
June 7, 2018 at 10:03 am
I'm not sure you want to CROSS APPLY the 2nd use of the splitter function. I may have misunderstood your requirement, but I came away from reading it with thinking...
June 7, 2018 at 9:44 am
Yep. You've got it. The problem you had to begin with falls into the "Gaps and Islands" category, and in your case, it was the "islands" of both "flag on"...
June 7, 2018 at 9:36 am
June 7, 2018 at 9:02 am
Viewing 15 posts - 1,126 through 1,140 (of 4,820 total)