This is a text split problem. There are several good splitting fuctions talked about on this site.

otto840513 (3/28/2014)

---

I have 3 records grouped by ticket number(it is a field in my table), in 2 of them I have the same stdesc but in the other one I...

You can combine the two thus

SELECT CAST(CurrentDate AS DATETIME) + CAST(Time AS DATETIME) FROM Data

This will be a DATETIME value. So you might use a CTE to combine the...

Thank you, mcx5000.

The EXECPT might just be what I was looking for. I have not used it very often so do not think of it.

Thanks again,

sharonsql2013 (3/25/2014)

---

Out Table has date as '2014-04-25' and time as 12:00 AM , 1:01 Am ,12:10 pm etc....

I need to see records for last two hours ...

How should I do...

There are several third party packages that can help with this.

That is the problem. He puts in 90 and it changes to 60. ...

ms-techie (3/25/2014)

---

Get output of SQL Procedure and assign it to a variable used in WHERE Clause

Later I want to use this variable in my code in the WHERE Clause

Declare @ProjectNo...

If there are several columns that need changed you may be better off creating a new table and inserting the data there.

As Grant said you need to check...

If you have T-SQL code you want formated, show use the code.

SSMS does not format queries or their results. You need to format the query manually.

You should use something like .NET to get and format the results.

On BOL look at "Cast and Convert (Transact-SQL)" see "money and smallmoney Styles"

Use dynamic SQL to set a character string with the CASE

See if this helps:

SELECT

DB_NAME() AS DatabaseName, T.[name] AS Table_Name, AC.[name] AS Column_Name,

AC.column_id AS Ordinal_Position, TY.[name] AS Data_type,

...

First thing in the morning here so not a lot of time.

Remember that the ISNULL causes the query to be non-surgable. (index not used)