auke.teeninga (4/3/2014)

---

Sean Lange (4/3/2014)

---

Good call on the bit field. I try to avoid them myself,...

Welsh Corgi (4/3/2014)

---

I regret the post.

I do everything to help my users.

I check the execution plans, add missing Indexes, rewrite the code, etc.

I would never do anything to hamper development...

WADRIAN68 (4/3/2014)

---

Hi

I want to loop through rows and append values to a declared variable. The example below returns nothing from Print @output, it's as if my @output variable is...

I agree with Lowell 10000%. There is no reason to dictate that the development is not allowed to use a certain technology because the DBA mandates it. I like your...

What is your actual question here?

Assuming the code you posted in your original post is what you...

auke.teeninga (4/3/2014)

---

I think the trigger still contains a logic error...

Currently it updates the datechanged even if the values remain the same. Maybe if the field was called DateUpdated a change...

pharmkittie (4/3/2014)

---

Doh! I had filters on (in Visual Studio: Right click on dataset, select dataset properties then filter from left menu). The logic was negating my efforts in...

vigneshkumart50 (4/3/2014)

---

Hi,

I am using this query to sum two column

REPLACE( CONVERT(VARCHAR(32),cast(round(isnull(sum(R1.[OBM Dollars] + R.[Current Cost]),0),0)as MONEY),1), '.00', '') as [Total Cost],

But I get this error "Operand data type nvarchar...

vanessa4biz (4/2/2014)

---

I have tried:

ALTER TABLE dbo.tablename

ADD CONSTRAINT DF_Date_format

check (SDate LIKE '%[1-2][0-9][0-9][0-9]/[0-1][0-9]/[0-3][0-9]%')

******But this does not work for VARCHAR data type ********

and

I...

pharmkittie (4/2/2014)

---

Right now everything is on my workstation. I am only accessing my local instance of SQL Server for SSRS and for running queries via SSMS. This is...

TheSQLGuru (4/2/2014)

---

1) The older style joins are not just worse syntactically. They have been deprecated and at some point in the future will NOT WORK any longer. Some...

If you...

asita (4/2/2014)

---

Sorry,

A table called pptList it has 500k rows, 7 columns

out of these 7 columns, we need to work around on 5 columns

which is

1) Segment column has 3 values SEG,MOR,CLN

2)...

That is pretty much what I said but yours is much easier to read...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...