If you have a legal obligation that prohibits gaps in your invoice numbers, then what I would do is on a rollback is after the rollback is completed on the...

TheSQLGuru (6/2/2014)

---

CREATE TABLE XXXX_XX(

[DM_CV_AGGR_FACT_POLICY_COVERAGE_ID] [int] IDENTITY(1,1) NOT NULL,

[POL_TYPE_ID] [int] NULL,

[GENDER] [varchar](1) NULL,

[DRIVER_AGE_RANGE_ID] [int] NULL,

[CARRIER_ID] [varchar](11) NULL,

[C_ST_ALPH] [nvarchar](10) NULL,

[LIMIT_ID] [int] NULL,

[BIZ_MONTHYEAR] [int] NOT NULL,

[BIZ_YEAR] [varchar](4) NULL,

[BIZ_MONTH] [varchar](2) NULL,

[TOT_POLICY_COUNT] [int] NULL,

[TOT_VEHICLE_COUNT] [int]...

Many good items listed in the posts above, but I missed one that is a real pet peeve for me:

- leading ; when defining a CTE. Sorry, but semicolons...

vkundar (6/2/2014)

---

Please find the ddl

CREATE TABLE XXXX_XX(

[DM_CV_AGGR_FACT_POLICY_COVERAGE_ID] [int] IDENTITY(1,1) NOT NULL,

[POL_TYPE_ID] [int] NULL,

[GENDER] [varchar](1) NULL,

[DRIVER_AGE_RANGE_ID] [int] NULL,

[CARRIER_ID] [varchar](11) NULL,

[C_ST_ALPH] [nvarchar](10) NULL,

[LIMIT_ID] [int] NULL,

[BIZ_MONTHYEAR] [int] NOT NULL,

[BIZ_YEAR] [varchar](4) NULL,

[BIZ_MONTH] [varchar](2) NULL,

[TOT_POLICY_COUNT]...

Would need to see the DDL and...

ramrajan (6/2/2014)

---

I have a query

declare @leveltype varchar(100)

set @leveltype = '1,2,3'

select *

FROM DefaultLevelNames where leveltype in ( select [values] from Split(@leveltype,',') )

Here is the result...

vkundar (6/2/2014)

---

Hi Lynn,

Tables have PM / cluster index key on identity columns or the VARCHAR(1) . These VARCHAR(1) is nullable but I did search the tables there were no recs...

To properly answer your question regarding the tables where you have this issue we would need to see the DDL (CREATE TABLE statement) and the definition of the clustered index.

Simplest...

Not really sure what you are expecting based on your post. It would help if you could post the DDL for your table, some sample data in a readily...

GBeezy (5/28/2014)

---

All,

I have a field in AX that is NVARCHAR(30). Sometimes the value has 5 extra characters at the end and sometimes, it does not. I have...

Looks like Sean beat me on this one. I blame 3rd world internet out here in Afghanistan.

adonetok (5/27/2014)

---

I try to modify a code to create a temp table but got an error.

How to fix it?

------------------------------

Declare @headerid Int

Declare @Providerid Int

BELOW CODE IS WORKING:

------------------------------

SELECT @headerid=HEADERID,@Providerid=PROVIDERID

FROM CLAIM WITH(NOLOCK)...

I think the answer here is hire a consultant.

Hard to say since we can't see what you see. You really need to post more information if you want good answers in response to your question.

Please read the...

yuvipoy (5/26/2014)

---

How to close the trace in order...