Any Ideas?

In SQL 2008 you could use the time datatype (12:35:29. 1234567)

Prior to that I would use Datetime.

I would use a datatype that understands date / time and not varchar.

There are...

you can do something like this in your trigger.

Obviously this is risky as if the output of DBCC INPUTBUFFR changes your trigger will break.

DECLARE @ProgramName nvarchar(128)

DECLARE @Text nvarchar(4000)

SELECT @ProgramName =...

you can use a tally or number table to split the string and do your comparison against each position.

-- create a temp tally table for test and fill it with...

this was a good question

I like the bit on the territories table if all the territories are apples.

From what I read it sounded like terrirtories of level 2 were apples and other territories were...

based on the information provided I like the solution that is in place if most of your searches are to retrieve territories that have the preference --Create a table that...

here is a quick sample I put together. I could probably come up with something more elegant after I think about it some more.

Depending on the amount of data you...

I have seen this strategy used before to help with merging disconnected datasets.

The reason they do not use the PK + 1 is probably because of the possibilty of inserting...

Depending on your sql security strategy ...

1. they should be able to connect directly with windows authentication setting up the connection right within Crystal.

Setup the user in Security for the...

What he is saying is that if you have Table 1 ( PK int ) and Table 2 ( FK int )

Lets say for instance you want to delete a...

Distinct does not apply to a single column -- it applies to all of the columns being selected.

The data model may be suspect if you need to use distinct at...

First, I would not use this table structure.

I would have a users table, a group table, and a GroupUsers table.

Storing all of the user ids in one column is a...

I do not know your table structure, but you can do something like the following.

--function to concatenate categories into comma seperated list by title

CREATE FUNCTION dbo.fn_GetCategoriesForTitle (@TitleId int )

RETURNS...

I would start by looking at activity monitor when the system is locked up.

Check for blocking transactions and see what host / application / statement is causing the issue.

This is...