Just a slight mod to my code. I added an ORDER BY.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[claim_report](

[claim_stat] [char](1) NOT NULL,

[status_note_code] [varchar](10) NULL,

[biller_cd] [varchar](20) NOT NULL,

[form_id] [varchar](10)...

Here is my first shot at your request.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[claim_report](

[claim_stat] [char](1) NOT NULL,

[status_note_code] [varchar](10) NULL,

[biller_cd] [varchar](20) NOT NULL,

[form_id] [varchar](10) NOT NULL,

[patient_nbr] [varchar](24) NOT NULL,

[patient_name]...

There is no status column. There is a column called claim_stat. Is this column you mean when you say status?

The problem with the WHERE clause is that it is forcing a table scan. SQL Server has to comput the difference betwen the two dates for every row in...

I am not talking about he-who-is-without-clues.

I am talking about someone else.

Because you are using the diag_1 alias for the column DIAGNOSIS_CODE and for the computed column with the CASE functions.

SELECT

RECIP AS recipno

,DIAGNOSIS_CODE AS diag_1 --...

This is what I came up with, but I think there are some other issues with the query.

SELECT

Locality,

Region,

ADOPTION,

...

OP == Original Poster

No, try running the following:

SELECT DATEDIFF(YY,'20111231','20120101') as age

My problem is I haven't created or used Maintenance Plans in so long, I have to look things up regarding them. I have been rolling my own processes for...

preetid2 (5/23/2012)

---

oh, ok Steve. so , if i don't have the previous file in the exisiting the folder, since there's no file exists my next backup will create the...

quillis131 (5/23/2012)

---

Hello,

I was wondering and cannot think straight on this, So I came with an idea of getting ideas/views from different people..

HARD RULE : When a Primary Key is defined...

derekr 43208 (5/23/2012)

---

Yes. As I explained earlier, the first query has a correlated subquery in the EXISTS predicate. This query is run for each row in the outer...

Check the setting in SSMS. Tools -> Options -> Query Results -> SQL Server -> Results to Grid and Results to Text.

Hope this helps, couldn't test it as you didn't provide and DDL for the table or sample data in a readily usable format.

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] ...