.

Are you pulling the top first record? No t sure if I understand clearly.

TOP (1) should be in your main table not on the derived table "sgn"

SELECT TOP 1mth,qty,

SIGN(S1.qty...

HOPE THIS HELP

DECLARE @TABLE_NAME TABLE(

NAME VARCHAR(30),

BDAY CHAR(8))

INSERT INTO @TABLE_NAME(NAME,BDAY)

VALUES('A','20130522')

INSERT INTO @TABLE_NAME(NAME,BDAY)

VALUES('B','20130523')

INSERT INTO @TABLE_NAME(NAME,BDAY)

VALUES('C','20130524')

INSERT INTO @TABLE_NAME(NAME,BDAY)

VALUES('D','20130525')

INSERT INTO @TABLE_NAME(NAME,BDAY)

VALUES('E','20130521')

INSERT INTO @TABLE_NAME(NAME,BDAY)

VALUES('F','20130620')

SELECTNAME,

DATEDIFF(DAY,GETDATE(), CAST(BDAY AS DATETIME)) [BDAY WITHIN 30 DAYS]

FROM@TABLE_NAME

WHEREDATEDIFF(DAY,GETDATE(), CAST(BDAY AS DATETIME))...

Thank you so much Gail.

ops sorry for the confusion. I mean the rows in a Table Variables NOT temporary tables.

have you tried putting name in your derived table?

@link = (SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'

AS SchemaTable

FROM sys.tables

where name like '%link%') as "table_name"

Looping on every row is not a good practice especially on large data. But it will give you an idea where to start 😀

select Col

from (select * from dbo.TESTTB) as X

unpivot (Col for cols in (col1, col2, col3)) as Y

if you want to insert the data from the two tables (header and detail) to test table you can do something like this...

1. get the inserted value in dbo.inserted

2. join...

I still don't understand some of the requirements.

StoreId, Open Date, Closed Date , ReOpen Date, Closed Date 2, ReOpenDate 2 .......

There can be no Reopen & Re-Close for a store...

Nice. Now I'm REALLY learning SQL.

Sometimes reading is not enough to learn.

You need to interact or post something so that someone can give comments and give a better...

You may want to try this steps.

1. Log on to the machine where the sql server instance resides.

2. Start SSMS. Use windows authentication (assuming your account have access to...

Looks like a challenging solutions and I want to try it. I'm not busy today because my boss is on holiday (yehey!!!) :-).Can you post some data and sample output...

You can use script task to filter the data.

Pull the data in a flat file, filter the row and insert the data in your sql server database.

http://blogs.msdn.com/b/mattm/archive/2011/11/17/what-s-new-in-ssis-for-sql-server-2012-rc0.aspx