Jerry Hung (10/29/2008)

You can use YEAR(datefield) and MONTH(datefield) such as

SELECT id FROM transactions WHERE YEAR(trandate) = 2008 AND MONTH(trandate) BETWEEN 1 AND 3

YEAR is just DATEPART(year, ___), MONTH...

Not sure how I can help on that other issue - looks like you have a couple of people who already have given you an answer that should work. ...

I am happy that worked for you - I think either YYYYMM or YYYY-MM would work the same way and ordered the way you want it.

Try this:

Select convert(char(7), date, 120) As DatePeriod

,count(*) As Total

From TBL1

Where Status = 'OUT'

Group By

...

That would be the best bet - but, if you don't find anything it is time to call the vendor. I have a feeling that regardless of what you...

Since the backup operation will occur on ServerA - and will run in the context of the SQL Server Agent on that server, the only way I see is to...

For passing dates into a procedure, I would recommend always passing the full date in YYYYMMDD format. The time will default to midnight.

If you can't do that - then,...

What you really should have done is to create the logins before restoring the databases. Google 'sp_helprevlogin' to find a procedure for copying logins from one server to another.

Make...

Are you sure those objects exist in the 'dbo' schema? And, are you sure you have permissions to grant access to those access (requires WITH GRANT privilege).

Well, this is going to be a bit harder and most likely will end up going to the vendor anyways. What you need to do is isolate the trace...

Search this site for Tally Table - it is exactly what you are looking for.

Lookup REPLACE in Books Online:

SELECT REPLACE(description, 'Jasper Conran', 'JC') ...

If you still have the trace output available - search the text data for the word 'locked'. Basically, you need to identify the request that is being returned that...

The only thing I would add would be to make sure the joins are correct. Using outer joins (LEFT) will return all rows from TableA and only matching items...

I would bet anything that the...