select * from table as t

where not exists(select * from...

Ashwin M N (12/30/2008)

---

create table temp (id int identity(1,1),Name varchar(50))

insert into temp (name) select 'IP 20867 Corona'

insert into temp (name) select '19"-RAC - C60184-03'

insert into temp (name) select 'HEEFA Tower...

Thanks Jeff Moden 🙂

Do you want one row per invoice?

Already suggested

Jeff Moden (12/29/2008)

---

I don't use SSIS but I believe there's a Bulk Insert task available in SSIS. The reason I don't use SSIS is because I do it...

What? 😉

mithun.gite (12/30/2008)

---

sir, thanks for the reply

its a long sp of balance sheet and earlier it is using dynamic sql now we need to do some modification and needs to add...

As far as I know the only case that I needed to use semicolon to terminate the statement is when I used GO as the procedure name

create procedure go

as

select 45...

[sniped]

select empid,'Allowance1',Allowance1 as amount from your_table union all

select empid,'Allowance2',Allowance2 from your_table union all

select empid,'Allowance3', Allowance3 from your_table

order by empid

One more query

select dateadd(day,number,'20090102') as BiFriday from master..spt_Values

where type='p' and dateadd(day,number,'20090102')<'20100101' and number%14=0

http://www.sommarskog.se/dynamic_sql.html

Read about Cross-tab reports in sql server help file

Franco_1 (12/23/2008)

---

1. Here is the code I'm using:

declare @dt as datetime

set @dt=CONVERT(varchar(8), GETDATE(), 112)

print @dt

The result is :

Dec 23 2008 12:00AM

How do I get only Dec 23 2008?

2....