Viewing 15 posts - 991 through 1,005 (of 5,504 total)
The answer is Zero. 😀
First part:
I have to select all the fields that are not NULL from T3.
Except the fact that we don't really have "fields" (that's more a...
September 10, 2011 at 2:07 am
Something like this?
select patient.dbpatcnt as id,
COUNT(*) as cnt,
COUNT(patient.dbpatcnt) OVER (PARTITION BY...
September 10, 2011 at 1:58 am
mysearchresult (9/9/2011)
GO
SP_SPACEUSED 'yourschema.yourtablename'
GO
The above gives the number of rows and other information regarding the table. This is the faster way to see the number of commited rows in a...
September 9, 2011 at 11:15 am
A ROLLBACK TRANSACTION only refers to the outermost transaction.
Straight from BOL:
It is not legal for the transaction_name parameter of a ROLLBACK TRANSACTION statement to refer to the inner transactions of...
September 9, 2011 at 10:49 am
Here's a scenario:
customer has billing and shipping address A for shipment #1.
Shipment #2 goes to billing addr A and shipping addr. B.
Shipment #3 goes to billing addr C and shipping...
September 9, 2011 at 9:53 am
preciolandia (9/9/2011)
Agreed to everything LutzM said. 🙂
Even though I appreciate the support I reported the post as spam due to the advert list in the signature.
September 9, 2011 at 9:12 am
SQLServerMS (9/9/2011)
Can anybody provide the script for getting the sequence
What sequence are you looking for?
We've asked several times to clarify.
Deleting/rephrasing old posts doesn't really help...
Until we know what kind of...
September 9, 2011 at 9:08 am
So you're basically getting a new schema where you have to map existing data to?
If that's the case I would request the new schema instead of an unknown XML structure...
September 9, 2011 at 5:45 am
You only need to reference the namespace in your query where it's actually used in the referenced XML element.
Based on your sample data you can query the Attrbute without referencing...
September 9, 2011 at 5:40 am
It's confusing...
One statement:
Elements can be added, deleted or even the sequence can be adjusted within the xml. Only the values of need to be persist.
Another statement:
value...
September 9, 2011 at 2:05 am
SQLServerMS (9/9/2011)
that is what i required, can u tell me how i can achieve this in sql script
What exactly do you mean by "that"?
Is your goal to have about 4mill...
September 9, 2011 at 1:02 am
notoriousdba (9/8/2011)
LutzM,Ah, you're so right. I see it now. My mistake.
No mistake. Just a different interpretation.:-D
My whole chain of arguments is based on the sample data provided and might evaporate...
September 8, 2011 at 12:48 pm
There's another option besides getting your boss to start reading up on Normalization:
You could use your design approach (which I consider to be valid btw) and create views to present...
September 8, 2011 at 12:43 pm
notoriousdba (9/8/2011)
E99999F00001
...
FT9999
FU0001
...
FUB999
FUC001
...
FUCJ99
What would be the next value in the sequence?
Based on the description this would not be possible:
F00001
...
FT9999
Instead it would be
F00001
...
ZT9999
Otherwise the value before B00001would be AZZZZZ and not...
September 8, 2011 at 12:24 pm
If my assumption of the concept is correct, it doesn't really make much sense to add the effort of a customized sequence just to cover 4 x the numeric range...
A...
September 8, 2011 at 12:04 pm
Viewing 15 posts - 991 through 1,005 (of 5,504 total)