Thank you for your quick response! The variable counts are not defined. Is it possible to create any function and use it?

Example:

SELECT ('%1 %2 %3', 1, 2, 3);

SELECT...

Thank you. I will try.

Thanks

Thank you! I am using Redgate 8 and happy with it so far. But wont be able to upgrade for now to use it against 2012 and later...

Can we do this in Redgate SQL Compare 8? We have the older version.

Thanks

Thank you Steven. This will be really helpful for me, i want to convert this to SQL FUNCTION and there is restriction we cant SET DATEFORMAT in the function....

Thank you. I will post the sample data at the earliest. We using NVARCHAR is to store the generic data and not specific to Date/Int etc.,

Thanks

We have the Data stored in NVarchar data type. Also, the data should exported to file based on the Data validation (Like Bad Data, Valid Data)....

I have got the solution. CROSS JOIN worked for me.

Thanks

Attached the Test Script File. CROSS JOIN didn't work.

Hi

Thanks for you qick response.

"Microsoft SQL Server (instance name)" exists in control panel on Node A and nothing there in Node B. I don't see anything related SQL resources...

Thanks for both of you.

Sysuser holds only User and Role detail but not the object level permissions. I have used sysprotects table to extract the info. The above...

Thanks Greg, this script will return immediate next run time of a job, but I am looking for a script which would retrun all the scheduled jobs for a particular...

This query works for me.

Thanks

Shuaib

Yep, I want to pick the largest ID for each status.

Thanks

Shuaib

Thanks all for the suggestions.

Shuaib