Thank you very much!!!

Thank you that fixed it.

Sorry if I was unclear , when I try to run this stored procedure, it gives me error that 'Incorrect syntax near Case'

Thanks Everyone , It was really helpful.

Thanks It worked!

Here is the table Structure:-

CREATE TABLE [dbo].[Test](

[projCode] [nvarchar](5) NULL,

[salesMonth] [int] NULL,

[salesDay] [int] NULL,

[salesYear] [int] NULL,

[decalYear] [int] NULL,

[transactionCount] [bigint] NULL,

[transactionType] [nvarchar](5) NULL,

[ExportDate] [datetime] NULL

) ON [PRIMARY]

AND SAMPLE DATA :-

SELECT '023','1','1','2011','0''0','VR' UNION...

i ran following query and it didnot provide me any error.

dbcc checkdb (tempdb) with no_infomsgs,all_errormsgs

I have run this on Sql Server Management Studio for SQL Server 2005(express edition) and also through enterprise manager for sql server 2000.When i just run the query it never...

Solution:-

SELECT COUNT(*) AS Expr1

FROM (SELECT partnbr

...

Thank You sir, this works great. but in above solution it gives me first empty 3 locations(In example below:- B7,B8,B9). Here is my scenario:-

A1 0

A2 0

A3 1

A4 1

A5 1

A6 0

A7...

we have db2 database in our company for as/400. in that we hav julian date column.

for example julian date for 9/9/2009 is 109252

set @sdate = (SELECT DATEADD(dd, CONVERT(int, RIGHT(@jdate,...

thank you sir

Its SQl2000.

I am completely newbie so can you give me an example with cursor for above trigger?

Thank you very much!!!! You saved me!

We have a location grid here. For that We created a locations table.

Locations table has two columns :-

Location(varchar(5))

Filled (Boolean)

Now I need to fill this Locations table with data that i...