From this weeks weekly email

http://www.computerworld.com/s/article/9227712/AMD_adds_server_horsepower_with_16_core_chip

SQL2012 License Cost for 1 CPU $109,984.00 or if you get the BL485G8 with 2 chips £219,968.00 😀

Then of course you want to get it with...

this is my take on sample data and a solution

DECLARE @Forum_Posts TABLE (PostID INT IDENTITY, Subject NVARCHAR(100), Body NVARCHAR(100), CreatedDate DATETIME, ThreadID INT)

INSERT INTO @Forum_Posts VALUES ('Sub1','Bod1',GETDATE(),1)

INSERT INTO @Forum_Posts VALUES...

could you provide some sample data and the expected outcome based on that sample data (see the second link in my signature for help should you need it)

Wesley Snipes

bodged together some sample data to match the what the OP has provided so far and a couple of scripts to get the information out but will need more data...

No problem, as I said in the comments as well make sure you pick the right function depending on what your want your ranking column to look like.

I dont think there is in SSRS, but you could change the data set to include the RANK or DENSERANK function depending what you need then show that in the...

Again provide data and table sturctures and we can help you out (see the second link in my signature if you need help)

Knife

Googlewhack

references http://www.sqlservercentral.com/Forums/Topic1314315-1550-1.aspx

SSIS is not instance aware, it is server aware and is only used to query MSDB/FileSystem to list the packages stored within it when you connect to a SSIS server...

Can you provide sample data, ddl statements, expected outcome?

freecoder (6/12/2012)

---

I have an application where a user can upload the file to a directory. Coz the requirment of the user was only one upload first. I did the upload...

Whats the reason behind having the blank titles in the second rows for each AID?

CREATE TABLE [dbo].[abcd](

[Aid] [int] IDENTITY(1,1) NOT NULL,

[Title] [varchar](50) NULL

) ON [PRIMARY]

insert into abcd (Title) values ('test1')

insert...