Hi Goldie,

Do you have an index on UserID?

You are right, it will convert automatically. I believe it will attempt to convert the varchar to an int.

The explicit conversion is useful as it will catch any bad...

hi Goldie,

Before you posted that code I was trying to solve this another way - by concatenating all the comments and then searching for three blanks in a row

with cte(UserID,...

You need to use the CAST function:

http://msdn.microsoft.com/en-us/library/ms187928(SQL.90).aspx

Something like:

select cast(users as int) from clientsDB.dbo.firsttable where cast(users as int) not in (select users from MarketingDB.dbo.secondtable)

Then to do an insert:

insert MarketingDB.dbo.secondtable...

Hi. What is your current update statement?

Bevan

Hi,

You need to fully qualify your table names when comparing accross databases. i.e. DatabaseName.owner.table

'owner' will probably be dbo.

Write a query similar to the following and see how you...

The first list is sorted by nodeID - the second list starts with the parent (the one with no parentID listed) and then lists the child, then it's children (grandchildren)...

Hi,

Use a recursive cte to build up your structure. The [sort] column is only used to store the relationships (and therefore the sorting).

create table #temp(NodeID int, ParentNodeID int null,...

Hi Mh,

Is the logic wrong somewhere? If so, could you please explain further.

Or is it just that this query is not showing all 15 columns?

Thanks Lowell for the table creates.

Mh is this what you are after? If this is not right you may need to provide further explanation.

with cte(loc, online_order, non_onlineOrder)

as (

select loc,...

Hi,

Are you wanting to join table1 and table2 based on firstname and then join table2 and table3 based on ID? Try the code below and if that does not...

Clearly the best answer is New Zealand! 🙂

A first world country with solid infrastructure but relatively weaker dollar means you get more bang (code?)...

Can you please provide statements for table create and insert of some example data?

Thanks

I was just re-reading OP. If you have start and end date parameters you could just check if they are null...

-- Or you could use null as the...

Hi,

Is this in a stored proc? If so you can add a parameter that will define what criteria to use. See below:

---- Table and sample data

drop table...