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

TomThomson (2/14/2015)

---

How can it...

Quick answer, NCD (no can do), suggest uninstalling installing and attach the DBs

😎

Only two weeks, almost there!

😎

Further on Luis's post, simply look in the code for the pattern division by a column or a variable such as X / [column_name]

😎

Luis Cazares (2/12/2015)

---

djj (2/12/2015)

---

Ed Wagner (2/12/2015)

---

Sioban Krzywicki (2/12/2015)

---

Eirikur Eiriksson (2/12/2015)

---

Brandie Tarvin (2/12/2015)

---

jasona.work (2/12/2015)

---

Brandie Tarvin (2/12/2015)

---

jasona.work (2/12/2015)

---

Is it me, or is it at least once a week minimum someone posts a...

Sioban Krzywicki (2/12/2015)

---

Ed Wagner (2/12/2015)

---

Sioban Krzywicki (2/12/2015)

---

Eirikur Eiriksson (2/12/2015)

---

Brandie Tarvin (2/12/2015)

---

jasona.work (2/12/2015)

---

Brandie Tarvin (2/12/2015)

---

jasona.work (2/12/2015)

---

Is it me, or is it at least once a week minimum someone posts a "How...

Slight side step from Alan's brilliant answer and pitching a retro "blast from the past", here is an example that checks if the root tag has a closing tag, the...