Then whatever you're passing as @storekey is not returning anything.

Edit: as in - it matches no record...

You already have one example (look at GilaMonster's syntax above as to the "delimited" example).

As to the pivoting example - Here's as good an example as any.

http://www.daymap.net/blog/?p=6

Posting your table specifics...

Deleting rows in a table with an identity value doesn't change the next identity value. The value is preserved, so the identity is maintained.

Unless you TRUNCATE TABLE...

You'd want to look up two separate concepts (different sides of the same coin).

If you plan on doing this a lot - you want to set up what...

Not to be contrary - but three and four-part names anywhere other than the FROM clause is now considered deprecated. The "correct" syntax these days is to use multiple...

What are you trying to do? Just curious.

If you have access to VS2005 Pro or better, you also have access to build custom aggregate functions, which will also give...

GilaMonster (2/26/2008)

---

It they're written badly, they can be.

Personally, I've not found views to be a problem, unless there are layers upon layers of views. If views reference other views which...

True with one caveat - ORDER BY during...

Good! glad that worked....

Why not just apply the formatting on the UI side?

What's being displayed is what the DB is storing (money is essentially the same as a decimal value with a constant...

What happens to make it "not work"? Looks to me that it's valid, although it looks like it should be rewritten as

select Substring(J.MAP_NUM, 1, 4) as MAP_NUM_LIMITED,

...

It does - and so your error would not seem to make sense. How are you running this?

I sometimes just highlight what I want to try, and...

Bob - try this one:

declare @start datetime

set @start = dateadd(d, (1-datepart(dw,getdate())), getdate())

select dateadd(week,-1*number,@start) from spt_values where type='p' and number<11

I'm using the spt_values system table as a "tally" table.

Also - Just...

Your issue is likely due to some of your full names not having a comma. That would result in CHARINDEX returning 0, and you passing a negative length into...

I know I'm a tad bit late to the party as well - but is there any chance to think toward improving "accessibility" As in -

http://www.section508.gov/%5B/url%5D

As in -...