patrick.palmer (3/25/2013)

---

I have a query that has two date fields that are Int....20050307. I need to convert them to date fields. 03/07/2005 I can not seem to get them to...

A bit expensive, but the following works:

declare @string varchar (100)

set @string = 'x:\folder1\folder2\folder3\test.txt'

select @string

select @string,reverse(right(reverse(@string), len(@string) - charindex('\',reverse(@string),1) + 1));

I'm thinking this would work on SQL Server 2000 when you could update system tables.

Without seeing the table structure, data, the different calculations that would be completed and what the data would look like when process was completed (the expected results), it is really...

I would look at using a check constraint instead of a trigger. Even if you implement the check in the UI, it should be in the database as well...

Maybe I will look at this tomorrow.

mishaluba (3/22/2013)

---

Lynn,

Thank you for your reply! The query you listed will return all of the cars and their parts, but this is not what I am after. My...

The way I would start, is do the first one manually creating the scripts as I went along using SSMS. Then it is just a matter of automating those...

javib (3/22/2013)

---

What I'm trying to accomplish here is to detect the instances where the same rep/hcp_cid combination appears at least twice in this violations table to flag the rep for...

I don't see a need for a recursive query:

IF OBJECT_ID('Car') IS NOT NULL DROP TABLE Car;

CREATE TABLE Car (

CarID INT,

CarName VARCHAR(16)

);

IF OBJECT_ID('CarPart') IS NOT NULL DROP TABLE CarPart;

CREATE TABLE CarPart...

SQLCrazyCertified (3/22/2013)

---

Steve Jones - SSC Editor (3/22/2013)

---

You are right, I did. I was thinking row and misread that. I've seen RBAC mostly as row based, not role.

In terms of roles,...

Try this:

select

a.code,

a.price,

new_field = a.price * b.percent * case when a.check = 1 then 8 else 1 end

from

...

Please, do not cross post, duplicate post. Please post all replies here.

davdam8 (3/22/2013)

---

Thanks Sean,

this is really helpfull.

However all the specification you gave are very terrifying, i'm only a rookie.

The work i'm in now requires the separation of the data into levels,...

javib (3/22/2013)

---

I have this query to express a set of business rules.

To get the information I need, I tried joining the table on itself but that brings back many...