Best place is to look on this site and then look on MS and google it

Thanks Bit Bucket

This is great, but this is not working...

Hi Mick

This would have been ideal if i am dealing with numbers, the problem is that the table has...

Hi Mick

Thanks , i don't have a separate table, this is for a Java application, i have to...

Thanks Jack

But i am looking to create a view, with this select statement, hope i cant do with...

Hi

This error occurs when there is a problem with the length of the data field, check the length on both tables 🙂

Hi Chris

No it wont cause any problems, Its like a monthly subscription mail ( i should...

Hi Chris

It works, it returns all rows with date (2nd) despite of what ever month (expect...

Hi All

This is what result i was expecting, Once again thanks for All your post

SET DATEFORMAT YMD

DROP...

Thanks Chris

I got a route to go from this, thanks, i will have...

Thanks G2, but this only gives me a record for last month, but i need users who are created on previous month as well, 🙂

Hi Visal

Thanks, i need all records that more than a months old despite of year, (...

Hi Derek, thanks for the reply.

Because its exactly a month as of today, i am looking for records whose...

have u got a list of server Instance name, if so load them on a table and run ur command across all the servers from a SP 🙂

Hope this helps

ops forget to mention, the table contains around 4 million rows 🙂