Run them, and click on the 'Display Estimated Execution Plan' button on the tool-bar.

This will bring up some icons/graphics showing...

Well i guess it does come down to individual preference and whether you have the time and budget to attend courses.

Though it is worth noting that nothing beats being mentored...

I dont know if there is an easy answer, maybe some one else can help?

but these prooblems can at times be worked out by looking at your execution plan.

have you...

What calender is the server using?

does this show the year as 2551?

Any budding DW designer/builder should get a copy of

'The Data Warehouse Lifecycle Toolkit' by Ralph Kimball

this will give you a really good understanding of techniques and theories behined DW....

I can fully recommend the red gate suite of tools (sponsors of this site) I had played around with the freeware tools from other companies and nothing i have...

have you tried dividing by 100 to move the deciaml point?

Do you have experience in DW/BI on other platforms and want to learn SQL server tools?

or are you new to DW/BI all-together?

there are a lot of books out there...

Try re-writing the query to use a join, rather than a sub-query as this will be more efficent.

Do you have the appropriate indexes setup on the tables?

could you post the table structures that your queries relate to and some sample data?

Wouldn't using 'select 1 from' just return you a coulm of 1's ?

Also 4...

You can not do it directly with the CREATE VIEW command, but it can be done by using dynamic SQL

declare @sqlcode varchar(max)

select @sqlcode = 'create view vw_MyView as select...

do you want to create a view from within your stored procedure?

Or do you want to create a view that returns the same data as your stored procedure?

please expand your...

you could try something like

UPDATE Employees

SET Day1= '0'

WHERE (isnumeric(Day1) =1)

UPDATE...

Try using the FLOAT data type

select convert(float, '2.11758236814')

you can then change this to NUMERIC if you want to as well

select convert(numeric(30,15),(convert(float, '-2.11758236814e-10')))

I mean break up the string into parts and...