In order to provide any meaningful answer, some more information must be provided, i.e. are the two tables in the same database, different databases on the same server, different SQL...

You were lucky this time, maybe it's time to implement source control and other recognized development practices;-)

😎

ramana3327 (2/19/2015)

---

Hi,

We have a database. It is enabled for mirroring. We need to delete the old records. That is around 500k records from a table. But it has foreign key...

Quick thought, unless you have 2 x LotsOfRAM on a single server, run ArcGis and SQL Server on two separate servers, my guess is that if those two start to...

Quick thought, the reason for passing parameters as string works in SQL is the implicit type casting it performs. This does not exist in VB/C# and therefore the data type...

Only 1001 to go:-D

😎

stpii (2/19/2015)

---

Hi!

Working in a project using Entity Framework (Code First)...

Until now the project has been connected to a (generated) SQL Server Compact 4.0 database,

but now we want to connect to...

Quick suggestion, you can try to search in any/all temp folders on the workstations used to develop those procedures, there is a slim chance that you might find the code...

Throwing my spanner in the works, what does the following code return on your system?

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE INT = 1000000;

DECLARE @BEGIN_VAL INT = 1;

DECLARE @END_VAL ...

ChrisM@Work (2/18/2015)

---

Here's another way:

SELECT

a.[Pax ID],

a.[Flight Date],

a.[Flight Number],

[Last Mod Date] = CASE WHEN x.[Pax ID] IS NULL THEN a.[Last Mod Date] ELSE x.[Last Mod Date] END,

[Status] = CASE WHEN x.[Pax...

Quick solution using the row_number function

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.PNRAdds') IS NOT NULL DROP TABLE dbo.PNRAdds;

CREATE TABLE [dbo].[PNRAdds](

[Pax ID] [int] NULL,

[Flight Date] [smalldatetime] NULL,

[Flight Number] [varchar](10) NULL,

[Last Mod Date]...

For fun, here is a 2012 and later method using TRY_CONVERT

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @Account TABLE(AccountNo varchar(3), MasterAccount varchar(10) )

INSERT INTO @Account

SELECT 'ABC','0000000ABC' UNION ALL

SELECT 'DEF','0000000DEF' UNION ALL...

The quick answer is yes, connection and users have to be set up, you might want to look into linking to AD if there are many users

:cool:y,

TomThomson (2/16/2015)

---

ChrisM@Work (2/16/2015)

---

Stop digging, Tom! For goodness' sake, you're coming across as a cranky old fella with a short fuse. This is not what we are used to seeing...

Quick suggestion, query the sys.sql_dependencies view

😎

SELECT

OBJECT_NAME(SD.object_id) AS OBJ_NAME

,OBJECT_NAME(SD.referenced_major_id) AS DEPENDENT_NAME

,SD.class_desc...