Viewing 15 posts - 3,436 through 3,450 (of 4,820 total)
If you have either the developer or enterprise edition of SQL Server, then you can use data driven subscriptions within SSRS. This allows you to specify a query...
July 15, 2015 at 6:29 am
xanuyo (7/14/2015)
Supose the original Table is:
NameValueSS
Xavier42
Abigail43
Muriel42
Xavier33
Abigail32
Xavier22
Muriel13
Now that I have the...
July 14, 2015 at 2:45 pm
ScottPletcher (7/14/2015)
Worst case, create the table in tempdb. Btw, yes, you can create a permanent (non-temporary) table in tempdb.
Doesn't tempdb get re-created using model on service start-up ? ...
July 14, 2015 at 2:33 pm
kwashington (7/14/2015)
July 14, 2015 at 2:25 pm
mw112009 (7/13/2015)
Are you sure ? I am confused on the followingDELETE
FROM DEDUPE
WHERE RID > 1;
Should it be --->
DELETE
FROM AbC
WHERE ???
When a CTE exists, it acts...
July 14, 2015 at 1:50 pm
scotsditch (7/14/2015)
"house:app.apx&resultid=1234,clientip"
or
"tost:app.apx&resultid=123,clientip"
or
"airplane:app.apx&resultid=123489,clientip"
I'm trying to pick out the numbers between resultid='...',clientip no matter what the rest of...
July 14, 2015 at 1:23 pm
Jeffery Williams (5/28/2015)
Tried it... He shoots, he scores... It worked.
I considered this however knowing ...
July 14, 2015 at 12:59 pm
Based on your initial post, I judged the likelihood of Jayanth's methodology actually being able to work with data that you had indicated would be different number of columns depending...
July 14, 2015 at 12:31 pm
Welsh Corgi (7/13/2015)
What is wrong with the following Statement?
update #tmpTotals set StateCount = (Select ISNULL Sum(DayCount),0) from #tmpTotals t where Loss_state = #tmpTotals.Loss_State )
As the first responder indicated, it's just...
July 14, 2015 at 12:16 pm
Scott,
Nice work. Don't have any idea how it will perform, but here's a prettified and full set script for the entire setup, including dropping the created objects, so...
July 14, 2015 at 11:58 am
inayatkhan (7/13/2015)
I need one query help let me explain my issue
create table #task(TaskId bigint unique, Name varchar(2000))
insert into #task values(1, 'Text Text Text Text Text Text Text <<Name>> Text...
July 14, 2015 at 10:09 am
Improvements are unlikely to come from the query without a change in the inherent structure of what you're trying to do, unless perhaps you can implement FULL TEXT SEARCH. ...
July 14, 2015 at 9:26 am
kwashington (7/14/2015)
July 14, 2015 at 9:17 am
.Netter (7/14/2015)
Apologies on the late reply was pulled on to another project, that sadly didn't work, can any suggest anything else?
You have to stop assuming that you implemented the suggestion...
July 14, 2015 at 9:09 am
gentong.bocor (7/13/2015)
it seems, system DSN that i created didn't detected on...
July 14, 2015 at 8:59 am
Viewing 15 posts - 3,436 through 3,450 (of 4,820 total)