I am getting this error if I do that way:

The multi-part identifier "sent_info" could not be bound.

I tried where isdate(t1.sent_info) = 0, that returned all the rows, please note that the values that are stored in t1.sent_info (varchar(150) datatype) are:

Request sent by user1 on 04/29/2009 8:49...

GSquared (4/28/2009)

---

It's an undocumented table that SQL Server uses for it's own stuff. Basically, don't even try to change anything in it, but it can come in handy for...

Thanks it works.

master.dbo.spt_values: please tell me about this table

I googled it and it says that table is a lookup table. What are type = P,

low, high, status columns of...

Thanks for the reply. I am getting the below error on running the below code:

Error: Incorrect syntax near 'Numbers'.

master.dbo.spt_values: please tell me about this table

I googled it and it says...

Actually I should get the following output(0 is non-onlineorder; 1 is onlineorder):

LocationOnline_OrderNon-OnlineOrder

loc114

loc210

loc310

loc401

Like I said before, I have 15 columns of order_refill i.e Order_refill1,Order_refill2,Order_refill3......Order_refill15.

In the similar way I have 15 columns...

Below is my requirement, both tables have same number of columns and same datatype. Here I am just giving

an example of the tables.

Table1:

empID LastName ...

This gives all the columns from table1 and table2, I only need the ones with differences. Thanks.

Great, it worked!! You are awesome!!

I am trying to use CHECKSUM function, I created a sample table emp(original table) and staging table "emp_staging", could you please correct the code below, as this code is not...

Please let me know any ideas? Thanks.

Here is my requirement:

1. I have a sql statement which is a source, I need to load this sql statement's output into Table1 which has 30 columns.

2. I need to...

I changed the trigger code, please review and let me know if it's okay. Thanks.

Create trigger dbo.updatetrigger

on dbo.Employee

After Update

AS

Begin

set nocount on;

Insert into dbo.EmployeeModified

(emp_id,dept_id,firstname,lastname,address_line_1,city,datetimelog)

Select i.emp_id

,i.dept_id

,i.firstname

,i.lastname

,i.address_line_1

,i.city

,getdate()

from...

I wrote the follow update trigger, please let me know if this okay or do I need to make any changes. Thanks.

Create trigger dbo.updatetrigger

on dbo.Employee

After Update

AS

Begin

set nocount on;

Insert into dbo.EmployeeModified

(emp_id,dept_id,firstname,lastname,address_line_1,city,datetimelog)

Select...

I also need a trigger on the final table, where only the updated information needs to be

stored in the table1_upd table. Could you please send me trigger code for me...