TJT (4/26/2014)

---

I am trying to decide on the best relationship scenario for the following:

Department has one or more Employees

Department has one or more Divisions

Divisions have one or more Units

Units have...

This is a simple version of timezone handling and time adjustments:

😎

USE tempdb;

GO

/*

NOTE: GMT is an obsolete standard, use UTC instead!

000 Dateline Standard Time (GMT-12:00) International Date Line West ...

Just add a filter to the update statement

😎

DECLARE @child TABLE

(

ID INT NOT NULL

,PID INT NOT NULL

);

INSERT INTO @child(ID,PID)

SELECT CH.ID,CH.PID FROM

(VALUES

(101,10)

,(102,10)

,(103,5 )

,(104,6...

dastagiri16 (4/26/2014)

---

After my search i found the solution for that...

and modified my procedure as below.lll

alter procedure limitedupdate(@i nvarchar(max),@j int)

WITH EXECUTE AS OWNER

as

begin

set rowcount @j-2 ;

execute sp_executesql @i

set rowcount...

Have you looked into EXECUTE AS

😎

J Livingston's solution is the proper way of doing this but for clarification, here is a corrected version of what you where trying to do using dynamic sql.

😎

declare @cmd nvarchar(255)...

In my opinion, learning the software...

MVIT (4/26/2014)

---

I have the DB server in EST timezone.So all the dates do get stored in EST.

But in the procedure before processing the date, I need to convert the date

to...

Do not want to underscore any preferences but I find...

I really did miss something (he...

Unless I missed something, you just have to add an order by clause.:cool:

Another way of doing this:

😎

SELECT

T1.ID

,DET.AILS.value('Age[1]','INT') AS Age

,DET.AILS.value('Name[1]','NVARCHAR(128)') AS Name

,DET.AILS.value('City[1]','NVARCHAR(128)') AS City

FROM dbo.Table1 T1

OUTER APPLY T1.XML_Uncompressed.nodes('Details') AS DET(AILS)

Looks more like a wishlist than requirements to me.

😎

Best bet is to find an ODBC driver for Btrieve (Pervasive SQL), at least that's what the files look like.

😎

Something like posting a link to it here...