gokturk413 (2/5/2014)

---

enter------------------------------intvalue--------out----------------intvalue

2014-02-05 08:56:51.230 -- 1----2014-02-05 08:57:05.990--- 2

2014-02-05 08:56:49.320--- 1----2014-02-05 08:57:03.490---2

2014-02-05 08:56:45.097---1----2014-02-05 08:56:57.840---2

2014-02-05 08:56:42.640---1----2014-02-05 08:56:55.727---2

2014-02-05 08:56:42.640---1----2014-02-05 11:37:46.493---2

2014-02-05 09:19:18.167---1----2014-02-05 08:56:55.727---2

2014-02-05 09:19:18.167---1----2014-02-05 11:37:46.493---2

2014-02-05 08:56:47.163---1----2014-02-05 08:57:00.737---2

please help when intvalue value change between 1-2...

This...

born2achieve (2/4/2014)

---

Hi,

I have two different databases in two servers(server1, server2). i would like to call the server2 database SP in server1 database SP. I know this can be achieved using...

You do not need to use a loop for this. Just modify the original suggestion so that you only return rows that don't already exist.

tshad (2/4/2014)

---

I am using Data Compare which does the following:

UPDATE [dbo].[EmployeeImage]

SET [ImageData].WRITE(0xffd8ffe000104a46494600010001006000600000fffe001f4c45...,

...

Try this thread. http://www.sqlservercentral.com/Forums/Topic1163878-391-1.aspx

You might also try searching the exact topic of your post. It returns a number of hits.

Please take the time to read the article that Keith referenced. We can't do anything with this big query you posted. We have no idea what the tables and data...

What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got started in earnest...

Using functions like that in your where clause will render your query nonSARGable. That means you have effectively rendered indexing useless.

I believe this is the post that Lowell was referring to. http://www.sqlservercentral.com/Forums/FindPost1536816.aspx

Again...run away from this type of approach as absolutely fast as you can. Auditing doesn't do any good if...

Like this?

select COUNT(*)

from eventlog

T where oldvalue = 'P'

and eventtime >= DATEADD(day,-7, GETDATE())

You would do yourself a world of good to change your datatype of eventtime to datetime instead varchar.

Generally speaking using try/catch is preferred to examining @@error.

Using try/catch will successfully trap the runtime errors encountered for items 1, 2 and 3.

begin try

insert TESTTABLE

select 1, 'Text1', 1

end try

begin catch

print...

greg.bull (2/3/2014)

---

Dear All,

I'm using INSERT..SELECT to gather data from a complex query into a holding table, this happens right at the start of an SP. The data is then used...

In addition to having to fight with an EAV you have delimited data stored. This is not a good design choice and if at all possible you should change that....

Check out this article. http://www.sqlservercentral.com/articles/71700/%5B/url%5D

It explains very clearly how to do exactly what you are looking for. Please post back if you have any problems getting it to work and...