When this occurs, use

DBCC

CHECKIDENT ('table_name', NORESEED)

to see if a value higher than the current identity value has been...

Dynamic SQL is usually a bad idea, but for a quick fix,

Set @select1 = 'Select Reference.RefID, Reference.CreatorString As CreatorString,  Genre.Type As Media, dbo.getRowRank(''' + replace(@Target,

I understand that you are not some sort of latter-day Sherlock Holmes with nothing to do but solve interesting mysteries (and in his case, hard drugs and fiddling), but you...

I think the confusion arises here:

>Then, all you need to do is use this stored procedure to get your data... it won't be in the form you asked for...

It crossed my mind that if you want to store this kind of data, the XML datatype might be of use. I have a feeling that it might be possible...

I didn't use a double colon, but it works for any string (subject to length restrictions).

declare

@str varchar(

Re indexing - I agree for the medium term, but on a longer view and if you have many such reports, you might want to look at a specialised reporting environment...

Try owner(schema) qualifying the table name. And yes, post the error and plan if that doesn't work.

I don't know (yet). How do you know it doesn't? I can't reproduce it.

I agree, and on a more general point. Scalar UDFs are not a panacea. If they are used in a multi-row SQL statement, they are best used as a shorthand for...

If you're going to do that, why not:

declare @sp_type int

set @sp_type = 5

 

declare @datesarg datetime

set @datesarg = case @sp_type 

when 5 then dateadd(mm,-1,getdate())

when 6 then dateadd(mm,-2,getdate())

else dateadd(mm,-3,getdate())

end

select * from

sales

where Cur_date >...

The reason a leading wildcard slows things down is because you can't use an index. The index is arranged in (an) alphabetical order, so to find things quickly you need...

You can't rely on SQL using a lazy OR, i.e. ignoring the second disjunct if the first is true. Even if it did sometimes do that, which I don't think...

The full text search capabilities in SQL Server offer a reasonably wide range of functionality, which could perhaps be set up as a basic system and subsequently improved in response...

Should have added that your joins would need to be left joins, and the where clauses amended to handle NULLs, otherwise new venues withut any reservations would never show up...though...