Brandie Tarvin (10/3/2013)

Can you see...

I've encountered some issues as well:

http://www.sqlservercentral.com/Forums/Topic1501074-433-1.aspx

Can you be a bit more specific on what you want to achieve?

Table DDL, sample data and desired output are appreciated.

Regarding replies: you can edit your subscriptions for each post....

Hmmmm. Weird.

Maybe it is suddenly blocked here by a firewall.

Still, I cannot change the avatar in my profile, as...

It defines a namespace.

Use XML Namespaces

You might want to give a little more explanation.

What exactly do you need to achieve? Difference can mean a whole lot of things.

Sample data and desired output are appreciated.

You'll probably need a cursor to update your values, because to calculate the OneStopOrNot column for one row, you need the calculated result of OneStopOrNot column of the previous row.

With...

Which version of SQL Server?

You only use date and time if you need them seperately.

For example, for a lot of data you only need the date part. The birthdate is a good example.

In SQL...

I think the main difference is that a log backup actually does a backup?

When you install SSRS on a server, the web service is installed as well.

You can retrieve reports from this web service once you have them deployed to the server.

Rendering and...

I sure hope that guy solved his problems 4 years ago 😉

I learned both languages by self-study, and they are both easy in my opinion.

Looking at the future and...

Add Namespaces to Queries with WITH XMLNAMESPACES

To get some decent answers, it might help if you post table DDLs, sample data and desired output.