The calculation depends on the value of the system parameter @@datefirst during the session where you calculate the first day of week.

By default this is set to 7, meaning Sunday....

There is an article by Brad McGehee at http://www.sqlservercentral.com/articles/Editorial/66637/ (Online T-SQL Scripts and Copyright) which discusses exactly the issue you're asking about.

You might find helpful answers in the article...

That's strange...

The @sql variable is declared as nvarchar(max). So it should allow to store more than 8000 character.

Could you provide sample data (as attached file) that would (slightly) exceed...

Just change the col type of caseid in #test to uniqueidentifier.

Hi,

I didn't notice that the resulting columns need to be dynamic. Sorry.

As far as I know, dynamic pivots only can be done using dynamic SQL.

In order to sort the result...

Please don't cross post.

further discussions please on thread http://www.sqlservercentral.com/Forums/FindPost723433.aspx

Hi,

maybe you could start with the code snippets from this post http://www.sqlservercentral.com/Forums/FindPost714447.aspx

The problem looks similar.

Hi,

would you please be a little more specific on what you're trying to do?

For reference on how to post data please see http://www.sqlservercentral.com/articles/Best+Practices/61537/.

For a start you could look up "FOR...

Hi Barry,

focussing on the question of the OP you're right that a rectilinear arrangement or any other structured solution won't be an optimum (even for boxes).

What I had in mind...

Based on the link Barry's previous post an additional question needs to be answered:

Are you looking for the number of equally shaped bottles per box (meaning all bottles have the...

AlexT (5/14/2009)

---

Yes, very interesting point of view, but syntax is looks very complicated.

old style do the same and looks much clearer

DECLARE @Table TABLE (CUST_NO INT, PriceRule CHAR(1), Discount numeric(8,2))

INSERT into...

You're welcome. Glad I could help!

Hi,

the problem is that you're selecting from an XML string with a namespace.

You need to declare the namespace in your select statement.

Running the following code should return 'GB'.

Note: Make sure...

Did you look up "job steps [Transact-SQL]" in BOL?

It'll give you a lot information on how to set up a job either using TSQL or Management Studio.

As far as I know a DELL can be shipped with downgrade rights to...