Sweeeeeeeeeetttttt

I thought i was done but didnot account for values with a count of '0'

So how would i return '0' for descriptions i.e. any of the results that do not...

Thanks that was what i was exactly looking for

thanks again

I did construct a query based of a query in stack overflow as below, but still donot understand how this works. and still cant separate the first and the last...

Sample DDL in the form of CREATE TABLE statements

CREATE TABLE [dbo].[FinalStore1](

[AID] [smallint] NULL,

[AssociatedTableID] [smallint] NULL

) ON [PRIMARY]

CREATE TABLE [dbo].[StoreAssociatedTable1](

[AID] [smallint] NULL,

[AName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AssociatedTableName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON...

no i am trying to connect these three table

well none of the columns explicity match each other. the table A stores the name of the associated table name.

[AssocTableName] [nvarchar](50) NULL stores the name for the associated table

data:

1...

The relationship stems through the Associated Table so the associated table has the corresponding values for the first table. Did that answer your question ?

Thanks Chris the query worked

thanks again

Thanks and sorry for the question, i was trying to insert the same record twice. Sorry about misleading you guys.

thanks

that worked

Thanks,

Convert(datetime, DATEDIFF(day, 0, GETDATE())) worked

IF EXISTS(

select 1 from Xlog where LogDATE >= cast(getDate() as date) -- should this be datetime if i have Sql server 2005?

...

DDL

CREATE TABLE [dbo].[Status](

[ID] [int] NOT NULL,

[Type] [nvarchar](5) NOT NULL,

[Status] [nvarchar](10) NULL,

[OpenedByID] [nvarchar](15) NULL,

[OpenedDate] [datetime] NULL,

CONSTRAINT [Cause_PK] PRIMARY KEY NONCLUSTERED

(

[ID] ASC,

[Type] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY...

Thanks for the help , and it is sort of hard to explain what i actually want expect to put it as how i have already. Thanks for all the...

Thanks for the reply,

i am looking for Null values and based on those null values i want to update a column in one of the tables. A trigger that would...