Viewing 15 posts - 571 through 585 (of 2,894 total)
To combine all records from one or multiple resultsets use UNION [ALL]
To combine all columns from one or multiple resultsets use JOIN (eg. INNER, LEFT/RIGHT OUTER, FULL OUTER)
If you...
March 18, 2013 at 3:02 am
SpinyNorman (3/15/2013)
March 15, 2013 at 8:18 am
How big your table is? Or, better way, how many records will stay in the table after purge of records for the last two years?
You might find, that moving the...
March 15, 2013 at 6:51 am
please suggest to have pk at table level
I guess you have no choice here. PK can only be set "at table level"
...every time remove pk before proc executes then...
March 15, 2013 at 6:07 am
...
If app connections are made with a service account for example, it will be difficult to distinguish which specific user dis something....
It's quite common design when DB connection is made...
March 15, 2013 at 5:59 am
Can you try this one (with index enabled):
SELECT
[Extent1].[ValuationDateID] AS [ValuationDateID],
[Extent3].[TransactionRef] AS [TransactionRef],
[Extent3].[Counterparty] AS [Counterparty],
[Extent2].[BookName] AS [BookName],
[Extent2].[Category] AS [Category],
[Extent2].[Type] AS [Type],
[Extent2].[LifeLicence] AS [LifeLicence],
[Extent2].[Manager]...
March 15, 2013 at 5:22 am
Ough, that's fine. I just couldn't see all closing brackets from first glance.
There are many different reason for this error to happen.
Have you seen this one? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36409
March 15, 2013 at 4:16 am
Note, dbo.DelimitedSplit8K is the fastest way to split sting in T-SQL (it only will marginally loose to CLR implementation). Also, what will happen if your Category will include 3 or...
March 14, 2013 at 1:21 pm
romah (3/14/2013)
Now, I got the following error:
"Category" is not a recognized table hints option. If it is intended as a parameter to a table-valued...
March 14, 2013 at 11:53 am
With Jeff Moden help ( dbo.DelimitedSplit8K string split function - http://www.sqlservercentral.com/articles/Tally+Table/72993/ )
you can do just this:
declare @mytable table (SNo int, Category varchar(100))
insert @mytable
...
March 14, 2013 at 11:27 am
Keep searching.... :hehe:
I also like to invent bicycles in my free time. Stupid clients/employers, they don't like to pay me for spending time on such an exciting hobby of mine...
March 14, 2013 at 10:20 am
ChrisM@Work (3/14/2013)
Eugene, that is absolutely spot on, and your last sole-user sample is an excellent demonstration of the distribution limitation. However, the sample sets provided by the OP are in...
March 14, 2013 at 4:38 am
RVO (3/13/2013)
I saw some of his stored procedures - good code.
I think he has a point. A few years ago at...
March 14, 2013 at 3:58 am
Viewing 15 posts - 571 through 585 (of 2,894 total)