well based on how i read your description, it sounds like a simple calcuated column could be used;

ALTER TABLE [dbo].[GV_STNDetails]ADD STN AS RIGHT('0000' + CONVERT(VARCHAR,[From_StoreCode]),4) +RIGHT('000000' + CONVERT(VARCHAR,[STNID]),6) PERSISTED

if you...

did you test this script yourself yet?

does it run?

does it raise errors?

ray is this for a web page or for a winform?

for Winforms, i usually create a binding source,

set the binding source.Datasource to your datatable, and finally set the the .Datasource...

what i posted was a proof of concept; if you need to add...

you took a picture in pointing at a mirror obviously.

that's why the steering wheel looks funny 😛

consumable sample data: note there are gaps(no "WednesDay" data for example), so a calendar table or case will be needed to get the values:

With MySampleData(CCDATA,CCDATAcompletedTIme)

AS

(

SELECT 54,'2013-04-16 13:56:00' UNION ALL

SELECT 52,'2013-04-16...

As far as i know, only ONE catalog will ever appear for a SQL server linked server...and that is the list of objects in the database the linked server points...

unlike all of you guys who completed all their tax paperwork in January and already got your refunds back, my yesterday was

non stop juggling of funds so I could write...

something like this is what i have saved in my snippets,a nd modified for your question:

SELECT * FROM

(

select name as DBNAME,STATUS,

CASE WHEN (STATUS & ...

it means that if you start a BEGIN TRAN,

if ANY error occurs in the transaction, instead of moving on to the next statement and continuing to process(the default...

Sean Lange (4/16/2013)

---

Lowell (4/16/2013)

---

Sean Lange (4/16/2013)

---

jimoa312 (4/16/2013)

---

... DO NOT RUN THIS IN PRODUCTION!!!!!!!

...Run this ONLY ON A DEV/TEST server!!!!

One last thing...did I mention that you should not run this in...

Sean Lange (4/16/2013)

---

you should...

really?

to me, the WHERE just does not look right:

I see two huge issues:

first, each EXISTS seem to reference THREE tables, and there's no joins...i don't even think it should work:

WHERE...

Minnu (4/16/2013)

---

Hi,

Below is the query am using..

create or replace trigger tr_stud

after insert or update or delete

of stud_code , name

on stud

referencing old as old new as new

for each row

begin

...

it's been a long time since you followed up on this, and you've changed which tables you are referring to.

did you fix the issue on MODEL_CODE and now have the...