stevet-1034619 (2/26/2010)

But, from a programming standpoint on the presentation layer, you have to display local time because users will not get UTC, GMT or otherwise. So that just means extra...

If you know that you want null in column 4 just change your insert.

INSERT INTO #Table1

SELECT

Table2.Column1,

Table2.Column2,

Table2.Column3,

null

From Table2

There is a significant difference between varchar(4000) and varchar(max). When specifying the size the number must be between 1 and 4,000. Max however behaves differently. The max amount of data...

hester84 (2/26/2010)

---

If you have to work with extensions to a 3rd party application, you need to follow their pattern. I worked on a large health-care system (same as Sean's?), that...

One thing to keep in mind is the date storage for the system you are working in. I worked on a very large enterprise level health insurance system where the...

If your are diligent during the development process to script all the changes you can include a change rollup script as part of the install for the new version. The...

There are lots of people here that can help you. However you first need to help us help you. You need to post some table definitions, inserts for some temp...

This is a class I got from somewhere on the Internet. I modified a bit to suit my needs. If there are more rows than will fit in an excel...

Is this for a windows app or a web app? It makes a big difference because most people will not allow Office to be installed on a live webserver. The...

This conversation reminds me of a time when a developer decided that he would change the way an audit table was used. His idea was that using GETUTCDATE() was more...

24.

For example i just ran it with start = 19 and end =22

output was:

19:15, 19:30, 19:45, 20:00, 20:15, 20:30, 20:45, 21:00, 21:15, 21:30, 21:45, 22:00

Of course some conditional divide by...

--EDIT--

My comment from 4 years ago was so wrong I removed it as to not be misleading. :blush:

This sounds a lot like a school project. Why in the world would you need something like this otherwise? That being what it is this was a fun challenge!!

Here is...

Good point. The real deal is that the datatype was implicity set to have 4 decimal places and the round function will not change the datatype. If you really wanted...

Not sure I agree that it is more "proper". Depending on...