It specifies the format of the convert (see help or Books On Line). Format 112 is YYYYMMDD so converting it to Varchar(6) just 'loses' the day. There are...

You can use:

WHERE Date > dateadd(yy, -1, getdate())

if you're using a DateTime field.

or

WHERE Date > CONVERT(Varchar(6), dateadd(yy, -1, getdate()), 112)

for "201209" format...

Note these are not very efficient for large data...

1: Works OK for me with the following issues:

declare @ColumnName varchar(50) --<< ERRORS ON THIS LINE<<

declare @sql nvarchar(max)

set @ColumnName = 'd_tid'

set @sql = 'select ' + @ColumnName + '...

Do you have any indexes on [tmp_load]?

It should speed up the joins if you created appropriate indexes

e.g. on dq_org_dist_id & dq_rec_seq_nbr.

Not so. You have to add a timestamp if you want one.

Even better!

BTW - I...

declare @time decimal(5,2);

set @time = 95.25;

select cast(@time as int)+(((@time-cast(@time as int))*.60));

Try this. It uses Jeff Moden's 8K splitter - full details on this site...

declare @temp table

(

Sno int, Text1 varchar(200)

);

insert @temp values (1, 'Batch 58701, Sub -000 .');

insert @temp...

select * from sys.syslogins ?

Something like this?

select char(ASCII('a') +1)

Why can't you use a transaction?

Golden rules of an interview:

Try to relax & enjoy it.

Listen carefully to questions - keep alert.

Show interest.

Have a list of questions to ask. Also ask questions/show interest in any...

Based on what we've got so far, this could be what you want:

--=======================================================

-- Test data:

--=======================================================

drop table #temp;

create table #temp

(

col1 int,

col2 char(1),

col3 char(1),

col4 char(3)

);

insert #temp values ( 1, 'X', 'M', 'abc'...

This looks easy enough to solve given a bit more information.

Can you post the queries that gave the results above, and if you posted some sample data you would most...

GSquared (8/28/2012)

That's what's called a "Table Values Function", and it's 2008+....