I know you don't want the 0 as your place holder. I'd go with the "?"

I don't have an example since I handle all the backups, etc..., but here are a couple of links, the second one is about backups:

http://www.yukonxml.com/articles/smo/

http://www.sqlmag.com/Article/ArticleID/45855/sql_server_45855.html

Depending on your background you may...

Sure you can, but if you want to restrict access based on IP address you will need a firewall setup to do that. You also will want to have...

parackson (9/2/2008)

---

yes the last number is a punch type but not necessary a start or end.... Sometimes you will only have a Shift Start(300) and a Shift End(303).. ...

You have a couple of options depending on your comfort level. You could do a batch process that calls sqlcmd and does the backup there. Or, you could...

parackson (9/2/2008)

---

Unfortunetly I think this goes back to how I described my issue......

We are on track as to how the data should be displayed

However it is not getting the correct...

GSquared (9/2/2008)

---

I don't know if this will be a problem in your case, but the above code will track the gaps as if they were present.

For example, look at the...

Do you have anything that distinguishes an in-punch from an out-punch?

This is close, but without knowing an in from an out a little more logic will be required to distill...

Okay, so now check all the input/output columns in the transforms along the path. At some point there has to be a spot where the column is set to...

Interesting find. I knew about switch, but I really dislike the syntax in SSRS.

No SQL Server does not treat large varchars as text.

One thing to keep in mind when restarting the SQL Server service or rebooting the server is that your buffer and procedure caches are cleared which will cause the server...

When you run a command-line install of SQL Server Express you can specify that only the Database Engine and connectivity tools are installed so that SSMS Express, etc.. are not...

I don't know how SQL Server handles streaming, but I do know that it will be likely that bringing a large image file across the network using SQL will take...

I am assuming you are getting this error from a .NET application. It looks like, based on the error, your application has a logic error so that it is...