View Complete Post
I have @temp that take 5 random rows from sp_get_Randomly. The sp_get_Randomly return top (5) of myTable and only select id to improve performance. This
5 rows are unsorted(in @temp). When I inner join it with MyTable, the result insert into #tempNew sortly. My problem is here: I want to #tempNew remain unsorted like @temp. How can I stop sorting there? I Know I can unsort it with “Order by newid()”
again. But is there anyway to keep same discipline of @temp in #tempNew, too?
In a table i have two column
From front end i m passing parameters like(1,2)OR(2,1)
i want to get a count of the pattern like (1,2)OR(2,1) only so i will get count 2 for the abv table.
tell me a select query to get the count?
1 My DataTable Return following Data
Acct Books AnnualAcct Books MonthlyAcct Tax Income TaxAdmin GH EqptAdmin Offc EqptAdmin Offc MiscAdmin Offc EqptBPO DE DE.USCorp Comp InsuranceCorp Legal CourtCorp Legal Court
but i require in this format
When you use the import wizard to copy data from SQL Azure, the list of table on the Azure server is out of order. This makes it very time consuming to find a particular set of tables.
Is this something that I could get some feedback on, or perhaps submit as an issue, either here or another forum?
Hi I have SQL 2008 table like,
AccountCode AccountDesc Value Date ...... ....
ACC1 Receipts Total 50.88 2010-12-25
ACC1 Delivery Total 140.12 2010-12-25
ACC1 Post Amt 798.88 2010-12-25
ACC1 Check Amt 31.70 2010-12-25
ACC1 Cross Amt 90.82 2010-12-25
ACC2 Receipts Total 50.88 2010-12-25
ACC2 Delivery Total 140.12 2010-12-25
I have a calc'd measure that depends partly on measure group a and partly on measure group b. It is associated with measure group a. When I process measure group b FULL, is SSAS smart enough to "update" my calc'd measure?
Even if I dont process measure group a?