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...

Not a really solid solution but you could alias your tables with a lot shorter name. For example, PERS_SVCMBR_TBL a

then your select would lose around 14-15 characters per line.

Not the...

I think you are wanting to elminate rows that only contain spaces?

simply add where [Field] ''

SQL treats multiple spaces in a field as an empty string. Alternately you could...

You are going to need to use a sum() function to get the total. It is impossible to tell from your post what column you want to total. The basic...

Since all the data is ultimately converted to string when exporting you should be to do something like this.

isnull(cast([YourFieldHere] as varchar(max)), '')

That way all your null values will just be...

try something like this:

select left(@a, 15 - charindex(' ', reverse(@a)))