my version:

note how i provided ready to paste-and-test code for the table and sample data?

if you can do the same in the future, you will get much better, tested answers.

With...

no foreign key for audit tables, usually, in my experience.

...

if it were me, i would make it like this:

i added an identity, and a column at the end with a default of getdate() so i know when the record...

CONSTRAINT [PK_JOB_POSTING_AUDIT_1] PRIMARY KEY CLUSTERED

you don't want that;

since this is an audit table, the same pk in the primary table of course would be updated multiple times.

the audit table...

you copied and pasted the exact same description, which apparently i misunderstood the first time.

copying the same thing and pasting it again doesn't help at all.

As I read it, the...

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...