I'm not sure how big your tables are, but the following will perform a table scan instead of using an index which will cause huge performance issues on larger tables

WHERE...

try using min or max. Either one works

I used the table names you provided in the original to try to guestimate the joins for your view. Try this:

Create View OneRecordPerLoadID as

select A.Load_ID, D.NAME1, A.HM_TRAILER, A.HM_ARRIVAL_DATE, A.CITY,...

Not sure what you are asking. The Code I gave you will return the Load_ID, Min and Max as well as all associated data with the Min record all...

here's a dynamic pivot table approach. Just note that if access is granted through a role, then specific select privileges are needed to run this dynamically

create table #t1 (name...

try this

declare @t table(

LOAD_ID int,

NAME1 varchar(30),

HM_TRAILER int,

HM_ARRIVAL_DATE smalldatetime,

CITY varchar(20),

STATE varchar(2),

TMS_EXT_REF_ID int)

insert into @t

select '59','Norman Cofield','478',Null,'BELTON','TX','20' union all

select '59','Norman Cofield','478',Null,'TYLER','TX','40' union all

select '59','Norman Cofield','478',Null,'WHITE OAK','TX','50' union all

select '59','Norman...

How about performing the update through a stored proc and then you can encrypt the data going into the database? You can also decrypt as necessary on the retrieval...

Not very clear on the requirements. What is the Code field for? Why would they want to add X numbers to the table? What is returned -...

How's this? I get distinct for both the Mast_Cat field and the Parent_Cat field so there won't be duplicates in the results set.

Table Create

create table xmmldata(

id int identity(1,1) not null,

MAST_CAT...

palla.sureshbabu (7/20/2010)

---

Hi ,

i need to create a trigger that needs to be fired on a table when that table is idle for two hours.can anybody help me with...

Arjun Sivadasan (7/20/2010)

---

Mike do you mean to say that the following select statements are not the same?

create table #table(col1 int, col2 int)

select * from #table

select col1, col2 from #table

If so,...

Using 'Select *' is not a good thing and shouldn't be used. You should take the time to type in the field names

Yes, a linked server would be needed, but be careful joining it in queries. Depending on the size of the tables, it could be a significant performance hit.

you can use -o to write to an output file and -e to write to an error file. This will give you some idea as to what is happening....

You probably need to look at the file itself. One of the rows is probably causing the error. Have you tried to run bcp from command line (witout...