asita (7/9/2013)

---

Hello All

I am using SQL server 2008 R2, i have a table called dbo.JJ_CARSDATA_Header, some how this table data is getting deleted,

is there anyway how to know , when...

First things first. We need some consumable ddl and sample data. I created this for you this time so you can see what I mean.

if OBJECT_ID('tempdb..#Something') is not null

drop table...

Also, if you give @RunningTotal an initial value of 0 instead of null you could remove the case expression.

...

DECLARE @DtBegin datetime,@DtEnd date,@dtDif int,@RunningTotal int = 0

...

UPDATE #QuirkUpdate

...

That looks pretty good. One recommendation, I would add the keyword CLUSTERED after PRIMARY KEY. And add a comment that it MUST be clustered. Yes I know that the default...

Vertigo44 (7/9/2013)

---

Sean Lange (7/9/2013)

---

Vertigo44 (7/9/2013)

---

Ok I have finally had time to circle back around to this query. In my attempts to follow the Forum Etiquette thread I ran into a...

Guitar_player (7/9/2013)

---

Yes , I have tried using the basic names

SELECT COLUMN_NAME, TABLE_NAME

FROM INFORMATION_SCHEMA.COLUMNS...

hidayah (7/9/2013)

---

Hi All,

I'm a real newbie in SQL. My job demands me to learn it which I found out to really attractive.

I was told that, having the last line(AND P.Deleted=0)...

Vertigo44 (7/9/2013)

---

Ok I have finally had time to circle back around to this query. In my attempts to follow the Forum Etiquette thread I ran into a slight problem in...

Please note: this thread started in 2008.

JoNTSQLSrv (7/9/2013)

---

Hi guys ,

I live in INDIA. For one year i have been working in sql server 2005 as a developer and i never got opportunity...

I think using 1 table should be fine if all the data is reasonably close to the same columns.

However you should not use ntext. The text and ntext datatypes...

No need to make this complicated. Just figure out your connection string like you did you original variable.

public class Program// note the class name, here

{

public static string MyVariable { get;...

Maybe another approach would be to create a new database and then script all the objects and transfer in the data? For the small amount of data it shouldn't take...

rayh 98086 (7/8/2013)

---

Hi,

Thank you for the risk you took as I sincerely appreciate the help and is working as needed. =)

I also need to have this parameter decide on...

nicholasferri (7/8/2013)

---

Hi, i have a program that returns a list of sites with siteIDs in excell/csv format. For each site id there is a record in my database table.What is...