Viewing 15 posts - 661 through 675 (of 698 total)
Try finding an example that is not convertible to a numeric datatype but that returns true in this function.
That's impossible 😛 as per the definition of the function, ISNUMERIC only...
August 10, 2009 at 5:24 am
It's just the way that SQL Server deals with Monetary data. It's always got four trailing spaces for decimals, and the decimal symbol (".") is interpreted as being the symbol...
August 7, 2009 at 9:19 am
Essentially, the reason why it doesn't work is because an integer is a subset of the numeric datatypes, and not vice-versa. Things which are numeric are not necessarily integers, while...
August 7, 2009 at 6:30 am
srikanth_pallerla (8/7/2009)
why isnumeric gives true when the content contains ','. May be question seems simple but i am new to sql server.
As per the Books Online page (http://msdn.microsoft.com/en-us/library/ms186272.aspx):
"ISNUMERIC...
August 7, 2009 at 5:37 am
Looks like I need to read it more carefully. I use Pivot tables all the time, so that might help to make some of my queries a bit more performant....
July 17, 2009 at 11:20 am
There's several different ways of doing it. The way I usually do it is to make a temp table with all the records that need to be updated, and then...
July 17, 2009 at 10:58 am
I ran through your post Jeff, I'm wondering if you're doing things any differently than the way I posted in my solution. I think I actually had been originally inspired...
July 17, 2009 at 10:55 am
Be careful with doing updates on a table-wide basis, if the table is very large and/or in active use. Doing an update on the entire table requires you to lock...
July 17, 2009 at 9:38 am
joseph_smithy (7/17/2009)
how do i set the scope to 'String'?
The scope isn't String, the scope's type is String. The value is the data set in your case.
July 17, 2009 at 7:14 am
Nazer and Shailesh, the problem with both of your ideas is that you assume he can hard-code the different course names in. If I understood the problem right, the reality...
July 17, 2009 at 7:03 am
Well, this isn't really the right forum for SSRS questions, but you've got several ways you could accomplish this. One of them is to use the ROW_NUMBER function that I...
July 17, 2009 at 6:04 am
Are you trying to add a field to your table which will indicate the "row number" of the row? In that case, what you want to do is add an...
July 17, 2009 at 5:49 am
You might be able to just do a CAST on your values and convert them to smalldatetime that way. EG:
Output:
03/25/1991
Mar 25 1991 12:00AM
VarCharDateSmallDateTimeDate
3/5/19911991-03-05 00:00:00
DECLARE @Date VARCHAR(200)
DECLARE @FixedDate SMALLDATETIME
SET @Date =...
July 16, 2009 at 10:19 am
Couldn't you instead pre-process the file? For example, if you know that every line has to have a certain number of items on it, you could read the entire file...
July 16, 2009 at 7:22 am
There's two problems you have. First off, you're trying to make a comma-delimited list to use IN with, but you're using strings, not numbers. What you end up having is...
July 16, 2009 at 7:19 am
Viewing 15 posts - 661 through 675 (of 698 total)