Recent content by hwkranger

sqlfable -- I liked your neat little trick. I might use it in the future. rose -- an alternative is: DECLARE @string nvarchar(100) SET @string = 'INDEX~OBJ~USR~GRANTCD~GRANTDTL~PROJCD~PROJDTL ' DECLARE @result table (string nvarchar(100)) DECLARE @Num int DECLARE @Pos int...

I answered my own question today. Answer is: Yes. If anyone else ever wonders this, the identity range management has nothing to do with whether data is available to a subscriber. It's just management of the range (which I suspected.) Which means, if you are working on a system that has a...

I have a database that will be used for replication. There are identity columns that will be auto managed on the publisher. During production, new bulk data is loaded into the database. (via SSIS) The data added from the WFE begins with an identity 100,000,000. The identity is managed by the...

George, I wouldn't have thought of that... I knew about the option from the execution side (and in subqueries), but adding it to the troublesome sps fixed it instantly! God Bless your guess!! Joe, I didn't try that, but if i did -- it looks to be about the same (in my eyes) as to issue as I...

So, I have this slow query... I try to keep the sps flexible, since we have so many (thousands) and business objects pass the same datasets around, so it's useful. Anyways.. I've found that there's a point where the query optimizer becomes retarded, its' around the 5 or 6 nullable parameter...

Open Business Intelligence Studio. Open the Server Explorer Open a new file for XML Schema Hold SHIFT + CTRL and HIGHLIGHT ever table in the Server Explorer Drag Onto your visual XSD Designer It's uber slow, but now you're done. I also bet this isn't what you want -- but take a stab.

Why not? (i'm sure this will get me into trouble) Actually, it's because I was lazy. Not a good answer -- but if a = b, and you set a = b again is there real harm? (the real answer is yes, but do you know why?) Because everyone should have an nvarchar(5000) column on every table. It's the...

Check your folder permissions.

I know it's 1 table. That's why i did a self join. T1 and T2 are alias' My query does this exactly. Replace the words Table with the name of your table. Require once, alias'd twice I'm not even touching this one.

This would be the same as any data warehousing development process. Very carefully. :-) But seriously, for multi-linguage data, I expect that you have data keyed by language, I also expect that you should be building your dimension tables in respect to this. Get a good inventory on your...

No, it shouldn't -- but then it depends on how they did it. Remember that anything is possible. My guess is that these are missing "attributes" to which you are refering.

This is impossible as you will see below.. UPDATE T1 SET RelatedName = T2.Name FROM Table T1 INNER JOIN Table T2 ON T1.RelatedID = T2.ID jk. Cheers.

I'll give my 2 cents. George has the right solution (as almost always) -- I work in a world of dynamic columns -- so I can't always hard code my columns. I think i got this idea originally from TeamSQL about 5 years ago or so. I've made modifications to it for sorting and what not for my...

My brain isn't working this morning. I'm trying to figure out why when I'm catching errors I'm not able to see the actual SQL error through nested sps. ALTER PROCEDURE [dbo].[uspSitePermission_Insert] (@UserID as int ,@SiteID as int ,@HistoryID as int...

You can do this one of two ways, 1) use XML like listed above (and below) ALTER PROCEDURE [dbo].[uspRateZoneStructure_AddFromXML] @XML as xml AS --<?xml version="1.0" encoding="utf-8"?> --<RateZoneStructure> -- <RateZone>1</RateZone> -- <ContractorID>1</ContractorID> --...