UPDATE dbo.EPool

SET dbo.EPool.UIC = dbo.NAVMC.UIC

,dbo.EPool.TAM5 = dbo.NAVMC.TAM5

,dbo.EPool.NAVMCPO = dbo.NAVMC.PO

,dbo.EPool.OPFORTETotal = dbo.OPFORTE.OrgQTY

,PO_Over = CASE WHEN

...

Thanks Naveed...

I will try this.

For 1st query it is giving results. But, for 2nd query it is not giving any result. If I use first query, thru application it is taking more time and...

We had a similar problem, although it was using text files and other ODBC connections as the source. I also looked through the web, and unfortunately as far as i...

If you know activity why r u using phc_id...

you can directly use the activity in where clause.

Use this code

select left('hello/what/ru/doing?/happy/new year

',len('hello/what/ru/doing?/happy/new year

')-(len('hello/what/ru/doing?/happy/new year

')-charindex('/','hello/what/ru/doing?/happy/new year

')))

Sorry... I dont know any sites where you can get free exam. I feel you if you search on internet you may get some information on that.

I have also seen,...

Since you are planning to move all the database.. you can also consider moving all the system database also.

So that all the settings which you might have forgot to script...

If you want to find which are all the service running on the computer... i.e sql server, analysis service, reporting service.

You can find these service or installed services in surface...

select rank() OVER ( partition by group_name ORDER BY group_name ) as rank, group_name, value, from group

Try the above code for getting rank.

I did not know this.... I tried with some statements ... its really great to understand this.

Just try with these statements and post your comments.

select 5+2147483647

select 2545801376+2833558419

select 7758079223372036854775807+7758079223372036854775807

select 7758079223372036854775807+1

Just run...

I dont think loading the data to a file and loading it back to the data mart is good idea. Since loading into file... and again back to datamart.. will...

I think there is a miscommunication..... with the message I have posted.

As Gail Shaw mentioned if you have backup of the database where you have the previous version of the...

I think there is a miscommunication..... with the message I have posted.

As Gail Shaw mentioned if you have backup of the database where you have the previous version of the...

It is true that SSRS is limited when it comes to use parameters and specially default parameter. If we use the setting provided by SSRS then we need to be...