Viewing 15 posts - 9,211 through 9,225 (of 9,641 total)
In the XML the value you are getting is the datetime with the time zone offset. Is there a way for you to convert that in the C#...
February 25, 2008 at 10:13 pm
Are there ways, yes, but typically display is handled in the front end. There is no row number function in SQL 7, 2000 so to handle your...
February 25, 2008 at 9:58 pm
You have to allow Null or empty for the report parameter. Then you need to make sure your data source handles the null or empty string value. I...
February 25, 2008 at 9:54 pm
I can really only speak from a SQL Server perspective. If your application is data is like this:
Cars Trucks ...
February 25, 2008 at 9:49 pm
I would create the "glue" tables because I think it would take less memory than storing each driver's data multiple times.
February 25, 2008 at 4:16 pm
The error you are getting is because somehow passing an empty string is causing the len function to return 0 and then you are subtracting 1 and ending up with...
February 25, 2008 at 4:14 pm
Yeah, sorting that many records on the client, especially since you are using a data reader and putting in a custom collection would stink. Now you need to be...
February 25, 2008 at 3:02 pm
Did the vendor sell you the product and say that it would work with SQL Server? If so, IMHO, the vendor should be working to correct their buggy software,...
February 25, 2008 at 2:30 pm
I have only seen this error when connecting to remote SQL Servers and there have been network issues. If you are getting this error when on the SQL Server...
February 25, 2008 at 2:20 pm
Matt has a good point as well. I was assuming (yes I know what assume stands for) that all the columns were being returned and that there was a...
February 25, 2008 at 1:58 pm
Its always good when Jeff agrees with you on something. If you cannot have the sorting done in the app then dynamic SQL is the way to go. I like...
February 25, 2008 at 1:41 pm
I find this to be an interesting question since I have read 2 sides to the sorting question. One side says sorting should be done in the app and...
February 25, 2008 at 1:21 pm
I did a little test on my machine and by running profiler, it looks like it is getting the table definition for the table of that name in the user's...
February 25, 2008 at 12:19 pm
How are you passing the date? The safest way is YYYYMMDD. SQL Server will get that right.
February 25, 2008 at 11:54 am
I am not aware of a way to default this behavior. If you find a way let me know.
February 25, 2008 at 10:21 am
Viewing 15 posts - 9,211 through 9,225 (of 9,641 total)