You could just do value * 100 which would be 50 for .50

AndrewSQLDBA (11/9/2011)

---

Hello Everyone

This is yet another issue of duplicate data. This is very old data that is coming over from an old Unix and DB2 database. Just my luck.

In a...

Try what's suggested in this blog post

engrshafiq4 (11/9/2011)

---

Actually i am working on already developed application,where i am adding new features and modifying existing system.The previous developer have used these output parameters instead of using .Net.i do...

If you insist on passing back the error message as an output parameter instead of handling the error condition in .NET then your stored procedure(s) need to do something like...

I got it right, because I knew none of the other answers was correct, but I don't think the answer had the best wording.

I ran it on a dev server...

Hey Jason, did you get that? :w00t:

How about...

L' Eomot Inversé (11/7/2011)

---

Gianluca Sartori (11/7/2011)

---

Totally different topic: this thread asks how to format datetime values in T-SQL.

I think this is a very bad habit to kick and I...

sqlfriends (11/7/2011)

---

Ninja's_RGR'us (11/7/2011)

---

So when you rebuild you need AT LEAST another 4.8 GB of free space (unless doing it in tempdb). Since you only have 3.7GB left you have...

Gianluca Sartori (11/7/2011)

---

Totally different topic: this thread asks how to format datetime values in T-SQL.

I think this is a very bad habit to kick and I put together an...

adonetok (11/7/2011)

---

I need pass exact string format from getdate() to third party application in which I can not do anything.

The third party applicaton only take format like below(including space):

'11/07/2011 09:30:00...

I did notice what appears to be errors in your case statements for PreviousMonth and PreviousWeek. You have the same CASE condition for PreviousMonth as CurrentMonth and the same CASE...

Here's a post by Jamie Thompson about it, http://consultingblogs.emc.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using-temporary-tables.aspx

Yeah, SSIS might have issues with determining data types and such because of the temp table, but you never know until you try. There are some ways to "trick"...

What is the column and value that you would be splitting on? Are you working within a single database or will the new tables be in a separate database?

Depending...