I'm sure someone here could come up with a function that would parse your calendar table, but you'd be far better off creating a new calendar table that would exist...

Maybe this is a silly question, but why do the concatenation at all? You're putting the same string on the end of both values, so if they are equal...

Is there a trigger on the table? Does the table have any refernetial integrity constraints on it or pointing to it?

Are you just asking how to create the invoice number? What are the arguments to the proc going to be? Are you passing it the store and the...

What happens if you issue the below command before you run the select

SET CONCAT_NULL_YIELDS_NULL OFF

It could be that some component of your concatenation is NULL and therefore the concatenation comes...

How about:

declare @table3 table(n int,p int,t float)

insert @table3 (n,p,t)

select 1469, 2, 0

union all

select 1470, 1, -29700

union all

select 1470, 2, -50248.8

union all

select...

And so, a link to Hugo Kornelis's bin packing series, which may spark an idea or 2.

http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/30/bin-packing-part-1-setting-a-baseline.aspx

Hmmmm....

Let's say you had 50 rows, all with a quantity of 1. The target quantity was 5.

How would you want that brought back? All the possible combinations of...

Found this on the Symantec site for BackupExec:

http://www.symantec.com/business/support/index?page=content&id=TECH64648

How is the ID set up in SQL Server? Is it set up to be a windows authenticated id? If so, putting the network name and the password...

Download the express edition of SQL Server ( or better yet, spring for the $60 and get the developer edition) and play with them at home. There's nothing like...

It will split the string on whatever delimiter you pass into the function. If you pass in '|' and there is no '|' in the data, it won't split...

Sorry if this seem too simple, but where are you looking for the print statements to appear? Are you running this in SSMS?

Looks like it works fine as long as you use the proper delimiter in the function call:

declare @team varchar(max)

set @team = 'a,b,c,d'

select * from dbo.SplitParameterValues(@Team,',')

Gives me:

value

a

b

c

d

2 things:

If you set CONCAT_NULL_YIELDS_NULL = OFF, does that change the behavior?

The @@rowcount in your 'else' block will only ever return 1 because all you are returning is the row...