Where is the Stored Procedure? Lol

Lol, I was half way there, Write a Stored Procedure utilizing a "function".

CREATE FUNCTION ODD_or_Even

(@Digit nvarchar(3))

RETURNS varchar(4)

AS BEGIN declare @Return varchar(30)

select @return = CASE WHEN

CAST(@Digit as decimal)/CAST(2...

CREATE FUNCTION ODD_or_Even

(@Digit nvarchar(3))

RETURNS varchar(4)

AS BEGIN declare @Return varchar(30)

select @return = CASE WHEN

CAST(@Digit as decimal)/CAST(2 AS decimal)NOT LIKE '%.0%' THEN 'Odd' ELSE 'Even' END

return

@return

end...

If it's a new server you migrated to, sometimes that server needs to be added to exchange.

Are the column names constant or dynamic?

You could rename every file in the folder to "name_date". The "good" ones would stay the same and the "bad" would be modified like the others.

You can also rename the file to your liking and then import.

Similar -

WITH CTE AS (

SELECT Project

FROM Project_Category

WHERE Category = '3')

SELECT c.Project

FROM CTE c JOIN Project_Category p ON p.Project = c.Project AND p.Category = '6'

I believe you can get rid of the table variables altogether. Add the inner join used to populate the second table variable to the beginning of the first query to...

A Sraight PIVOT could work too!

CREATe TABLE One(PoNum varchar(7),

Date varchar (15))

INSERT INTo One (PoNum, Date)

VALUES('P001', '2013-01-01'),

('P002', '2013-02-01' ),

('P003', '2013-02-10'),

('P004', '2013-03-01')

CREATe TABLE Two(PoNum varchar(7),

IteMRef varchar (15),

Qty int)

INSERT INTo Two (PoNum,...

SELECT

a.mins, a.stamp, b.mins, b.stamp

FROM

(SELECT min(value) as mins, min(t_stamp) as stamp

from @t

WHERE value = (SELECT min(value) FROM @t)) a,

(SELECT min(value) as mins, min(t_stamp) as stamp

from @t...

SELECT REPLACE('2b',SUBSTRING('2b',PATINDEX('%[^0-9]%','2b'),1), '')

Lol, CASE -

SELECT

AlternateName = CASE WHEN AlternateName = ' ' AND AlternateName1 <> ' '

THEN AlternateName1 WHEN AlternateName = ' ' AND AlternateName2...

PIVOT -

SELECT [1870], [1880]

FROM

(select yr_died

from @1870_1880_DAT ) AS SourceTable

--GROUP BY EJTranID, BranchID

PIVOT

(

Count(yr_died)

FOR yr_died IN ( [1870], [1880])

) AS PivotTable;

To Delete-

WITH CTE AS (SELECT keys, month, MIN(Usage) AS Usage

FROM #deletion

GROUP BY keys, month)

DELETE d

FROM #deletion d

...