Arun Jebakumar (7/30/2010)

---

I am able to see the edition in the license agreement that comes when I run the setup. But I wanted to know if there is a way...

To add to it, the default setting of your PROD DB should have the Right Click on DB - Properties - Options - Miscellanous - ANSI NULL default - ...

meichner, this looks like you used the Right Click --> Script View As --> CREATE To...

And URL for your SERVERPROPERTY from MSDN Online :

SERVERPROPERTY - MSDN

🙂

try this:

select serverproperty('Edition')

Also dig deep into SERVERPROPERTY function; you can find lots of information about the servers using that function..

Hope this helps..

Try this:

declare @tab table

(

ccode varchar(2),

ctype varchar(2)

)

insert into @tab

select 'A', 'L'

union all select 'A' , 'P'

union all select 'B'...

Anyways, take this:

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

DECLARE @NumOfDays INT

SET @StartDate = '01-JUL-2010 00:00:00.000'

SET @EndDate = '31-JUL-2010 00:00:00.000'

SET @NumOfDays = DATEDIFF(DD,@StartDate , @EndDate) + 1 ;

WITH Tens AS

(

SELECT 1...

Quite Possible... But would want to know if this is some kind of Home-work, is it?

If yes, then can u please update us with what you have tried till now?...

Yes ,Brian, right.. but there are better solutions to get teh latest ProjectID.. if you would provide us some sample data, your table structure, then we would happily solve your...

Try this buddy!

INSERT INTO [BE].[dbo].[Resources]

([ResourceID]

,[ProjectID]

...

This will give u a load of replies for difference between x64 and IA64... basically those are Architestures....

Check out this URL : http://tinyurl.com/246n2qj

Try this:

-- setup test data

declare @Application table (appid int, appname varchar(30), [version] int, appCount int)

insert @Application

select 1, 'Excel',200, 3 union all

select 2,...

Can u attach a screen shot of your "Results Pane" alone with your current result set? I am stil unclear on your request. Just a shot in the dark, are...

Dint this work for you?

Select instancename,verifiedname from table where instancename is not null and verifiedname is not null

As it seems as simple, i guess i am missing something.. if...

My pleasure, Raffael! 🙂