Viewing 15 posts - 1,036 through 1,050 (of 3,666 total)
First thing that comes to mind is that when you were debugging the package, you were running it from your computer. Then you tried running it from the server....
September 18, 2013 at 2:10 pm
Shaun2012 (9/18/2013)
Im still not getting how to do it..im lost when using import
im using ssis 2008
You don't have to do an import if you're just copying a file. SSIS...
September 18, 2013 at 11:20 am
Why do you want to kill those? Why bother?
August 23, 2013 at 10:22 am
Sean Lange (8/19/2013)
No need for a case expression here at all. Just convert the value, it will give you the negative values just fine.
CONVERT(decimal (18,2),REPLACE(LTRIM(REPLACE(TestData,'0',' ')),' ','0'))
Duh!!! I missed that....
August 19, 2013 at 10:39 am
Try removing the - that's between THEN and CONVERT.
Does that work for you?
August 19, 2013 at 10:36 am
Sean Lange (8/14/2013)
skb 44459 (8/14/2013)
I want to populate the pdf form using large sql data
OK.
Why do you want to do this in t-sql? It is the wrong tool for the...
August 14, 2013 at 10:02 am
Nice code. Thanks for posting here. 🙂
You might want to add whatever question you have. 😎
August 14, 2013 at 9:32 am
You could use the CASE statement to look at the first few characters and build a number of rules to differentiate between the two.
You would have to review...
August 13, 2013 at 10:33 am
If you took 30 minutes to leatn about SQL Server you would know how to answer this yourself.
August 8, 2013 at 8:17 am
Good question.
Can you post the 2 queries? Maybe there's something else different that you're missing.
August 7, 2013 at 9:58 am
I'm sorry, but can you reword that question? I don't understand what you're looking for and I don't understand what that has to do with the topic of Date Incrementing.
August 7, 2013 at 8:30 am
Have you looked at what Visio can do? I've used it many times for database diagrams.
August 7, 2013 at 8:09 am
I need to find the time and add a Resource page on our PASS Chapter website listing all of these.
August 6, 2013 at 9:40 am
Viewing 15 posts - 1,036 through 1,050 (of 3,666 total)