I totally agreed with Lynn Pettis. Criticizing is too easy and everyone can do this. But be a mentor and/or helpful to other is not everyone domain?

Thanks, my asnwer was wrong but learn something today.

The Victor T. Alvarado is right.

You can put the saqure braket [] arround the user and it will work fine.

But I would like to suggest and make...

I agree with soultower that you don't need any WHERE clause condition on 2nd column if you want to include all record of that column.

Your query will look like

SELECT

...

You desire query will look like.

SELECT

Data_ID

, DateTime

, Batt_Vltg

FROM

tableName

WHERE

DateTime = CAST((CONVERT(VARCHAR(10),GETDATE(),103) + ' 04:00AM') AS DATETIME)

Current...

I would like to suggest that initially have look on BOL (Book online) provided with SQL SERVER on any artical. It will really save a much time and develop the...

You can use the bellow syntax; to replace the table name with your desired table name.

if exists (select * from dbo.sysobjects where id = object_id(N'[TableName]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop...

I believe that you don't have a complete overview of the trigger. Have you imagine the implication of this you are doing?

Trigger normally used for the data to be...

You can use the ISNULL function provided by the system;

Here is the example

SELECT ISNULL([Last Date], GETDATE()) AS [LAST DATE]

You are using the start position by the variable @iPos1, which holds the first occurence position of require character. That why I get the position of the next occurence rather then the first...

You misplace the BEGIN 's END for the INSERT CASE. It should be before ELSE

I think you are asking for 

INSERT INTO table1 ( columns) SELECT coulmns FROM table 2

WHERE fpartno LIKE rtrim(@partno1) + '%'

Can you explain what you mean by system date change. You know every second the date is change and what you want to achieve by this. Detail description of problem...

Your table stucture does not show any unit information of product. Can you explain how the units stored in these table?

If Date already stored in the database table then why are you modifying and restoring it again. If you need the format somewhere to show the date then you need the...