Naomi N (11/30/2011)

---

How will you expand the solution when you have StartDate EndDate fields in your table and you want continuous intervals, e.g.

01/01/2010 - 01/15/2010

01/16/2010 - 02/10/2010

The above two...

What kind of development are they doing?

If it's anything like my shop, all our developers really need to use a common database for the common application we develop;

for example, If...

all 1900 plus in one shot:

i hope the 18 is actually the database name and not the ID?

sp_MSForEachDB 'INSERT INTO SpecificDatabase.dbo.DBTables

( DatabaseID ,

TableName ,

ColumnCount ,

UserAdded ,

DateAdded ,

UserEdited ,

DateEdited ,

Active

)

SELECT ''?'',

TABLE_NAME,

NULL,

'''',

GETDATE(),

NULL,

NULL,

1

FROM...

operating system service pack does not enter into the equation.

SQL Server Service pack is the piece to look at.

Windows NT 5.2 (Build 3790: Service Pack 2)

that's the OS of both...

you pointed it out yourself, i think...the backup was created with SP3, but then SP4 was applied. the server is now SP4, but the backup's Sp3, and no longer compatible.

i'm...

see this post bu Gianluca, and his crosspost to his blog;

it does exactlyt what you are after:

http://www.sqlservercentral.com/Forums/FindPost1212804.aspx

by coincidence, he jsut updated that older thread.

i think he wants to pivot three columns into twelve total columns.(four sets of three), but i'm just guessing at this point.

just guessing here, but i'm thinking you upgraded your server AFTER you created the backup, and system databases are restricted tot eh same version...client databases can be upgraded on the...

another testable example, based on sys.objects:

SELECT name from sys.objects

order by CASE

--crap with an underscore at a certain position

--gets banished to the bottom

WHEN SUBSTRING(name,3,1) = '_'

THEN 2

ELSE 1

END,name

i think you just need something like this:

SELECT BL = CASE

WHEN Business_Line IS NULL

...

page number is the exact same logic, just handled like this:

ALTER PROCEDURE GETSOMEDATA(@PageNumber INT)

AS

BEGIN

SET NOCOUNT ON;

declare @increment int

SET @increment = 10

...

a lame example:

CREATE PROCEDURE GETSOMEDATA(@Start INT,

...

can't you easily see the credential_identity column from select * from sys.credentials?

why do you want to rename the name column if the credential_identity column has the...

I don't use TOAD, but i do some Oracle conversions a lot.

i thought ALL concatenation in Oracle must use double pipes...why do i see you trying to + strings togehter?...

thanks drew!

I'd hang my head in shame for not knowing that but since it's outside of my typical comfort zone, I don't feel too bad.

That cleared up my query really...