Viewing 15 posts - 31 through 45 (of 89 total)
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
...
January 21, 2009 at 12:16 am
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...
January 4, 2009 at 11:02 pm
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...
January 2, 2009 at 5:49 am
SELECT *
FROM dbo_pod_surgery
WHERE phc_id="22/15729";
If you know activity why r u using phc_id...
you can directly use the activity in where clause.
December 30, 2008 at 7:36 am
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
')))
December 17, 2008 at 4:27 am
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,...
December 17, 2008 at 4:00 am
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...
December 17, 2008 at 1:02 am
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...
December 16, 2008 at 6:36 am
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.
December 15, 2008 at 4:25 am
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...
December 12, 2008 at 5:15 am
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...
December 12, 2008 at 12:26 am
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...
December 11, 2008 at 11:05 pm
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...
December 11, 2008 at 11:05 pm
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...
December 11, 2008 at 4:39 am
Viewing 15 posts - 31 through 45 (of 89 total)