and what is your expected output?

happy to help 🙂

how about creating your queries dynamically based on the columns they choose?

After they select the column you will know what tables they want and ifyou have acustom table that defines...

I think the sign function may slow things down as it would result in a function being run on a column in your where clause which will affect the use...

Sorry I'm a bit confused.

If all the code that you posted is uncommented is all of that code inside your function?

The second thing is you should be aware that having...

From reading books online it looks like error Number 50000 is generated from a Raiserror command when no error number is specified.

You might want to search though your code for...

Hi Derek,

Could you post the code with some sample table and table/index definitions

And the code that runs you TVF as well please 🙂

Thanks

Chris

I'm not 100% sure but I think it's because you have an UPDLOCK within the transaction.

Have you tried removing that table hint?

Please be more specific about your problem?

Please read the link below in my sig for advice on Posting Best practices 🙂

Count you not just have table that has new rows inserted into each day with the total count(*) at the end or beginning of that day?

That way you could...

Looks like confusing running around this thread.

I think what the OP mean't by no time was '00:00.00' which is actually still time, it's just the beginning of the date.

Hi Steve,

Another suggestion is that when you actually viewing your full list that you can select all. rather than having to tick every single topic you want to unsubscrbe from.

The...

EDIT -- Sorry was thinking of the wrong thing.

you might want to create a dynamic query for this type of problem

bad answer...

VARCHAR(1) is most definitly not the BEST answer, it should be char(1) or nCHAR(1)

Hi Jack,

Yeah I saw that one as well, first thing that I thought when I saw him say

I'm quiet new to sql but I have already made a few nice...