The Heap™ – Consultancy ©® - 2014-12-17 (page 1 of 2)

Paul White

1:08 AM

@JNK You're not the only one to suggest that. I almost changed my profile picture, but decided against it in the end.

ypercube

1:47 AM

@Kermit you missed a Vertica q at dba.se:

1

Q: Where do I find the tables that a role has access to in Vertica?

I'm trying to use the System Tables to fetch some metadata about the whole Vertica cluster at a table level (including permissions). Where can I find the information about permissions required to SELECT on a table? I've poked around in the GRANTS and ROLES system tables, but I can't find any ro...

vertica

swasheck

3:06 AM

OOCHIE BOOCHIE!!!!

these are new ones for me

> SQL Server detected a logical consistency-based I/O error: invalid encryption key. It occurred during a read of page (1:288) in database ID 2 at offset 0x00000000240000

(invalid encryption key?)

> SQL Server detected a logical consistency-based I/O error: invalid protection option. It occurred during a read of page (1:143) in database ID 2 at offset 0x0000000011e000

(invalid protection option?)

both in tempdb

RolandoMySQLDBA

3:27 AM

Good evening, DBA Gladiators !!!

swasheck

ARE YOU NOT ENTERTAINED!!???

ypercube

Hi @Rolando

swasheck

3:54 AM

well shutting down the service and running chkdsk resolved it. neat little issue (in POC environment so oh well)

Paul White

4:33 AM

did you GIVE IT A TRY!!!?

swasheck

4:45 AM

@PaulWhite eh?

Paul White

Rolando reference. Didn't make much sense.

swasheck

yeah. i figured it was a ref to him --- just didnt know what i should have tried :/

Marian

@swasheck detach db/set offline :D

swasheck

@Marian it was tempdb so i figured WTH ... turn off the service and CHKDSK

Marian

@swasheck yeah, don't take my point for real, because it's exactly what the other Paul recommends against doing

swasheck

4:48 AM

i know

Marian

good you solved your problem

swasheck

well it was in a POC environment so i felt at greater liberty to mess around. plus it was tempdb so ... meh

i know i'm late to the pop culture game, but is that "catching fire" movie any good? i'm trying to find something on netflix

Marian

6:31 AM

@MikeFal you get a vote for your PS effort on Tribal Awards (probably your only one :P)

ypercube

10:45 AM

Yey, 20k

7

Grats

Good job!

@ypercube nice!

11:52 AM

Thank you all!

Nice hat, Paul (the Aztec one)

Paul White

@ypercube Thanks. The theme for today is 20!

ypercube

I wonder if there is another hat for 30.

Meta discussions say that the total number of hats is 30 but noone is sure.

And I'm sure bluefeet is not allowed to say.

Paul White

No idea. Some of them are going to be hard to get on dba.se

And at least one is impossible.

ypercube

the Hairboat you mean?

Paul White

Yes. She's never posted here.

Hm. There are 30 listed hats, I think, and eight "secret" ones.

ypercube

12:02 PM

Hm. so 38, not 30.

I think the hardest for you to get will be the Naruto.

Paul White

Ha. Maybe. I'm not going to even try to get them all. I was after Time Lord, Red Shirt, and Aztec in particular.

I wonder if there might actually be 42.

38 seems like an odd number for SE to choose.

ypercube

12:21 PM

@PaulWhite I'm reading this question: dba.stackexchange.com/questions/86391/…

The statement is particular:

UPDATE #UserData
    SET CurrentPrice = OtherUser.Price
FROM #UserData BD
INNER JOIN ...

Could this cause any issue (I don't mean it's related to the OP's performance issue)?

I mean not using the alias with: UPDATE BD ...

Paul White

@ypercube Yes it could result in an unintentional cross join and updating the wrong rows. It should be UPDATE BD.

ypercube

Great, thnx.

Paul White

Probably is the cause of his performance issue.

bluefeet

@ypercube we aren't told anything about the hats

ypercube

@bluefeet So , I was right. You are not allowed to say anything. Not even that you know ;)

bluefeet

12:32 PM

:)

I wish I knew, then I could get all the hats

ypercube

I think 20-25 is achievable. Without much difficulty.

Paul is in the first page in the top scorers list.

with 22

bluefeet

I got the mullet hat today - business in the front, party in the back

ypercube

It's the period of the year when a downvote is acceptable.

bluefeet

a downvote on a pivot answer is never acceptable, even for a hat :)

Paul White

Equal #14 at the moment. I could do with a down vote somewhere, and +2 on my current +5 answer. Those would get me 2 hats. Would be briefly tied for #6 across the network.

bluefeet

12:39 PM

do you really want a DV? I will oblige as long as I can edit later to remove it

Paul White

@bluefeet Yep DV my question or something. Please.

bluefeet

on DBA? or SO?

Paul White

@bluefeet dba

bluefeet

I did your DBA question

makes me feel icky doing that though :)

Paul White

Thank you!

Kinda icky requesting votes to get hats, so we're even :)

bluefeet

12:43 PM

I think you should add a comment that says downvoter care to explain?

Paul White

Heh.

@bluefeet Hat acquired thank you. Feel free to un-DV. Anything hat-related I can help you with?

bluefeet

@PaulWhite now I have to figure out how to edit your question to un-DV it

Paul White

@bluefeet Done for you

bluefeet

thanks now upvoted :)

Paul White

Love your work.

bluefeet

12:51 PM

impressive

Paul White

Ugh. I could get another hat by asking a question using the app. But ... ugh.

Maybe that's enough hattage for the time being :)

Lamak

@PaulWhite I think that's only using the app?

Paul White

@Lamak Exactly. Can't bring myself to do it.

Lamak

@PaulWhite just opening and voting with it is enough

and then quickly close it

Paul White

@Lamak No I've got that hat already. There's a separate hat for asking a question using the app.

Lamak

12:55 PM

ah, then I'll never get that one (not that I actually have many hats, I think I'm just at 4)

Paul White

I wonder if it's even possible to ask a decent question using that interface.

Lamak

You can ask that same comment on meta and get a hat for it

Paul White

Ug. Asking on meta ug ug ug

Lamak

meta.dba dude

not meta meta

Paul White

Oh. :)

I think I'll leave it. I have many hats. Happy as I am I think.

Mikael Eriksson

1:06 PM

@PaulWhite Creative workaround.

ORDER BY
    T.SortMe + 1;

BTW. Is there a connect on the bug?

Paul White

@MikaelEriksson Not yet I don't think. I left it up to the guy that originally asked me a similar question by email (free consultancy service!)

@MikaelEriksson Unless SortMe contains int.max, but yeah.

Mikael Eriksson

@PaulWhite the bug fix would be + 0. That works to :)

Paul White

@MikaelEriksson Oh ok.

Mikael Eriksson

Watch a session of yours from pass 2012 I think where you demoed a lookup estimating 16 rows. This is about the same internal thing happening right?

Paul White

Very similar. That was a key lookup IIRC.

Mikael Eriksson

1:10 PM

Yep

Kermit

@ypercube unbelieveable... i didn't get an e-mail

Paul White

The +0 hack works, but I'm not going to add it as a workaround. Aside from the obvious objections, it would make fixing the issue with an index harder.

Really though, I had to ask my first question and self-answer to earn a hat :)

Ooo! New hat! Handegg.

Mikael Eriksson

@PaulWhite Of course not :). I was just fooling around with your query to see how it reacted to rewrites.

Paul White

@MikaelEriksson It was very creative :)

Mikael Eriksson

Just wait until you see the XML rewrite :)

Paul White

1:17 PM

Ha!

0

Q: Hat etiquette question

Is it bad form to ask a question just to earn a hat? Would it compound the faux pas to hope for five answers within thirty minutes to earn two? Hypothetically.

discussion

Lamak

lol

Paul White

I'm officially a hat whore :)

JNK

oh man you have so many secret hats

bluefeet

1:35 PM

@PaulWhite I'm pretty sure you won't earn a hat asking on a meta site unless it is Meta Stack Exchange

sorry to be the bearer of bad news

Paul White

@bluefeet I'm pretty sure you're right. But I had to try.

Lamak

aaaw

Paul White

Well. I didn't have to.

bluefeet

done specifically to prevent abuse

Paul White

Main site question it is then!

Lamak

1:36 PM

that would be fun

Master Database

1

Q: Hat etiquette question

Is it bad form to ask a meta question just to earn a hat? Would it compound the potential faux pas to hope for five answers within thirty minutes to earn two? Hypothetically.

discussion

Mikael Eriksson

@MasterDatabase Yes we know.

3

Paul White

@MikaelEriksson Could you remove your answer so I can delete the question please?

Mikael Eriksson

I would if I could. You have to unaccept first.

gone

Paul White

Thanks. This is fun isn't it. (I am so going to get banned).

And now I can't think of a single SQL Server question. Hm.

bluefeet

1:42 PM

@PaulWhite it takes a lot to do that. But if you want I can ban you from SO?

Paul White

@bluefeet Is there a hat for that? :-D

bluefeet

unfortunately no

JNK

There should be a jailbird hat

that's just some bars that go across your face

bluefeet

urgent please close this

-1

Q: URGENT SQL Request SQL Count between larger than a value

I have a database with a table name products. How do I find the number of listings (products) with a price value that is stored in (column name = "price") that is larger than $10. Thank you in advance.

sql

Paul White

Thank you in advance.

I always wonder about that phrase. Does that mean we wouldn't get thanked later?

JNK

2:02 PM

It's just a hollow platitude

Any SSRS pros around?

Paul White

The only one I know is Rob Farley, and he'll be asleep right now.

Lamak

@JNK @mmarie seems to be quite knowledgeable about it

Marian

@Lamak I was about to say the same about you :).

Lamak

nah, I just try to remember things I knew about it

JNK

I'll ask on SQL Help

Paul White

2:12 PM

#SSRS Q - Is there a way to abort a report execution if a subreport throws an error? #SQLHelp

Tweeted by JasonNKyle on December 17, 2014 at 2:10 PM

Aaron Bertrand

2:27 PM

@PaulWhite crazy hat dude!

JNK

@PaulWhite true to my word

Lamak

I'm not sure that what you want is possible though

JNK

Hey random Q for the smart folks in the room - would you have concerns about a "Lead DBA" who can't write a CREATE CLUSTERED INDEX statement without referring to documentation or getting help?

Asking for a friend ;)

Paul White

Yes. Everyone knows lead dbas use the GUI, which has no need of syntax or complicated options :)

JNK

not even that he was asking me

I made a note on a spec with a suggested CI

and he was trying to add it when I was at his desk and it took him like 5 minutes

er I mean my FRIEND

Paul White

2:39 PM

Wow.

JNK

yeah

I am considering talking to someone about it

I've mentioned it before

but that REALLY surprised me

The other huge red flag was when he had a FK constraint violation and couldn't figure out how to write a query to find the offending records

Paul White

I'm struggling to think of something constructive to say...

JNK

no need I'm just venting

nobody else here really understands how bad it is b/c they don't understand SQL that much

A good mechanic and a charlatan may be indistinguishable to you if you don't know much about cars

Paul White

Aaron thanks. On ✆ so can't link my reply

@AaronBertrand ^^^

Maybe next year we will have the option to combine shirts and hats. Would love to have the red shirt with the pirate hat.

bluefeet

@PaulWhite or blue feet?

Lamak

2:54 PM

@JNK next time give you should also suggest the code for it

Paul White

@bluefeet indeed!

ypercube

@PaulWhite Print screen with the shirt, photoshop, update profile picture, use pirate hat.

Aaron Bertrand

I would like to be able to rotate the hat. For obvious reasons.

Paul White

Too lazy/lacking artistic talent. Also no photo shop. Might try in the morning. It is a good idea.

Aaron Bertrand

Wow, this was a minute old, and a down-vote already? Guess I'll step aside for the person who really wants the bounty.

-1

A: Retrieving n rows per group

The typical way to do this in SQL Server 2005 and up is to use a CTE and windowing functions. For top n per group you can simply use ROW_NUMBER() with a PARTITION clause, and filter against that in the outer query. So, for example: DECLARE @top INT; SET @top = 5; ;WITH grp AS ( SELECT Custo...

Lamak

2:57 PM

@AaronBertrand you can

bluefeet

@AaronBertrand maybe to give you a hat?

ypercube

@AaronBertrand Maybe they want to give you a hat ;)

Aaron Bertrand

@Lamak oh yeah, I see that now, missed the controls

Lamak

@AaronBertrand yup, nice addition

Paul White

I would fix that down vote but hit my limit

And it will earn a hat, if you don't have it already

Aaron Bertrand

3:01 PM

@Paul can you define this a little better: the number of rows to list might vary per group

@Lamak Hmm, I can't rotate it all the way around

Lamak

ah, you are right, that sucks

Paul White

@AaronBertrand I'll have a go on this tiny keyboard, yes. Imagine a customer table and an orders table, where the customer row includes the maximum number of rows to list for that customer.

Aaron Bertrand

I bowed out.

ypercube

Why did you delete the answer?

Aaron Bertrand

Because other people obviously think they can do a better job.

No patience for that today, sorry.

Had an argument yesterday with a friend who was being a douche on facebook, and taking my dog for potential surgery today. Don't need additional aggravation.

Paul White

3:10 PM

Oh! Another annoying thing about the android app - can't see deleted stuff. Or hats!!

Aaron Bertrand

android <---- I think I found your problem

ypercube

It's the hat madness. People downvote to get a hat. Give bounties. Delete their answers.

Paul White

I know. I know. The wife has the flash apple ✆

ypercube

Does the apple app see the hats?

Paul White

I'm on my third bounty.

So ner

@AaronBertrand best wishes to the pooch. Oddly, our cat just came home today after surgery. $1300 worth!

Aaron Bertrand

3:14 PM

Mine is closer to $3000

Paul White

OK wow

Aaron Bertrand

All his paw joints on left hind are dislocated. No idea what happened.

Paul White

Ouch

ypercube

@PaulWhite I was trying to explain the downvote. Either someone wanted to get the hat for downvoting 5 posts or wanted to give the (mullet!) hat to Aaron.

Paul White

Yes I know hard to convey that I got that and was trying to be silly/amusing back

I could have used a smiley I guess :)

Aaron Bertrand

3:17 PM

Kris complained that I didn't include the extra credit option, then he posted an answer that is also missing it. shrug

ypercube

I suggest you undelete.

Paul White

It's not as good is it

ypercube

There aren't many sensible ways to do this, are they? I guess CROSS APPLY would be an option.

Mike Fal

@Marian Heh, thanks. That makes two, actually, that I know of. :) I'm not that worried about it, I'm up against SQLPSX.

Paul White

Apply with a correlated top variable was what I had in mind. There may be other ways

ypercube

3:19 PM

I could add a convoluted way I've used with MySQL

(that has no window functions, nor apply)

Paul White

Really it's about getting all the main methods on one place. Possible future close as duplicate target.

@ypercube sounds interesting!

Lamak

someone started a flagging thing on another chat

Paul White

Always fun. Unless your using an app.

James

Yo

JNK

oy

ConcernedOfTunbridgeWells

3:29 PM

Evening

James

@ConcernedOfTunbridgeWells Looks like it outside

What would you all expect if you were told an interview would consist of 'difficult TSQL' problems?

@AaronBertrand Did he just come home like that or something?

ConcernedOfTunbridgeWells

@James What sort of position?

James

@ConcernedOfTunbridgeWells Some sort of developer-DBA hybrid.

Aaron Bertrand

@James yeah, my wife has a habit of letting them out and then forgetting that she did so. They're beagles, and even though we have a physical and electronic fence, they find ways to get out. No idea what happened to him out there.

billinkc

@JNK don't use sub reports

ConcernedOfTunbridgeWells

3:33 PM

@AaronBertrand When I were a lad we had a beagle that my folks called 'Houdini' because he was next to impossible to keep in.

swasheck

@billinkc +1. would laff again

ConcernedOfTunbridgeWells

In the end they had a wire mesh fence made of the square mesh stuff used to reinforce concrete - that was dug about a foot into the ground.

JNK

@billinkc tres helpful

billinkc

That's Doug's advice. Says it's far too much of a PITA to use them. Pathetic logging, etc

JNK

but seriously I'm trying to just come up with some VBScript that will throw an error in the outer report if one of the subreports is empty

or has an error

I am not able to rewrite the report unfortunately

billinkc

3:35 PM

From what I'm given to understand, haven't researched it myself, the interface between parent and child report is ... limited

Lamak

@JNK what kind of error?

swasheck

i was up until 2am working through compiling regex to parse output from a certain tool ... then found something buried in the documentation of said tool that there's an output type that's more friendlier to data analysis.

confessions

JNK

The whole tale is, we have some reports that read from tables that may not be populated if theres some sort of issue for certain locations

ConcernedOfTunbridgeWells

@billinkc It's very good at giving cryptic and unhelpful errors if the configuration of the subreport isn't just so.

JNK

I fixed this for MOST of the reports by throwing an error in the STP if there is no data

The report generation and distribution are decoupled

so we don't want BLANK reports to go out to customers

billinkc

3:36 PM

@ConcernedOfTunbridgeWells Have you thought about a life in politics?

ConcernedOfTunbridgeWells

@JNK Run the report off a sproc that pre-validates the data and throws its toys out of the cot if it isn't happy?

JNK

@ConcernedOfTunbridgeWells the sproc does throw an error if theres no data

ConcernedOfTunbridgeWells

@billinkc I'm just about ready to take up a career in percussive stakeholder management.

JNK

the sproc runs in the SUBREPORTS though

so the report still generates with a bunch of error messages in the subs

I'd like to have the overall report bomb

swasheck

@ConcernedOfTunbridgeWells do you need a lackey?

Aaron Bertrand

3:37 PM

@ConcernedOfTunbridgeWells yeah people say beagles are stupid but they're actually pretty clever about escaping

ConcernedOfTunbridgeWells

@JNK I meant a sproc for the main report that pre-validates the data.

billinkc

@JNK Try Crystal Reports. Or Crystal Light

JNK

@ConcernedOfTunbridgeWells not practical

Though I guess I could combine all the other queries into one giant query

swasheck

@billinkc i believe in crystal light because i believe in ... cancer of the digestive tract

JNK

but then we are running hte report twice

ConcernedOfTunbridgeWells

3:39 PM

@swasheck Maybe a U.S. subsidiary?

swasheck

@AaronBertrand sorry to hear about the dog.

JNK

I was really hoping to be able to put some vbscript into the report along the lines of IIF(SubreportA.Isempty() or SubreportB.Isempty()...) THrow

swasheck

@ConcernedOfTunbridgeWells you've always wanted an internet punching device. this could be the mechanical turk version

billinkc

Export to PDF, OCR the outputted reports and verify there isn't a blank sub. Piece of pie

ConcernedOfTunbridgeWells

@swasheck Exactly. You might be on to something there ....

@JNK Why does the whole report need to bomb if data isn't ready?

JNK

3:40 PM

@ConcernedOfTunbridgeWells because the report saves to an mhtml that another process picks up and emails

ConcernedOfTunbridgeWells

Could you get away with a GIGO policy - if the data isn't present you just get a blank space where it is?

JNK

that's what we have now

So right now it sends a blank report

or I should say before I added the raiserror to the STP

ConcernedOfTunbridgeWells

What's the issue with what you have now - why isn't it fit for purpose?

JNK

so if the report is empty we want it not to save the mhtml

Right now I get the report header then an error message per subreport

Error: Subreport could not be shown. Error: Subreport could not be shown.

Error: Subreport could not be shown.

Error: Subreport could not be shown.

Error: Subreport could not be shown.

Error: Subreport could not be shown.

Error: Subreport could not be shown.

ConcernedOfTunbridgeWells

What problems does it cause - anything more serious than users whining about their nice pretty reports looking a bit messy?

JNK

3:42 PM

nope, that's the issue

these go to clients

ConcernedOfTunbridgeWells

OK.

JNK

however if its BLANK most times it means something else broke

so we need to fix that and rerun it

ConcernedOfTunbridgeWells

Could you have a separate master validation report that you run before bursting the reports out to the clients?

swasheck

hm. not to distract from @JNK and his pressing issue, but this sounds very interesting

bonappetit.com/trends/article/flat-white-coffee ... a "flat white"

billinkc

I assume there's nothing logged the report view... ExecutionLog3 or whatever it is?

Lamak

3:43 PM

@JNK how are you distributing the reports to the clients?

swasheck

@Lamak DMZ fileshare ;)

ConcernedOfTunbridgeWells

@swasheck I was drinking those is a cafe in Christchurch in 1995.

JNK

@Lamak decoupled process that reads recipients from a table and pairs them up with files to receive

ConcernedOfTunbridgeWells

They're all the rage here in London at the moment but (IIRC) originated in NZ or aus.

JNK

my original suggestion was to update that script and add a check for if the filesize is < threshold don't send

swasheck

3:44 PM

@ConcernedOfTunbridgeWells Oz, apparently

ConcernedOfTunbridgeWells

Basically a less frothy version of a cappucino.

That's my hipster moment. I was drinking flat whites before they went mainstream.

I feel like such a trendsetter now.

billinkc

I think it was Rob Farley that had mentioned that in one of the Summit "Understanding the US for foreigners"

swasheck

@JNK as @billinkc suggested, did you look at the ExecutionLog(n) tables/views in ReportServer database?

@ConcernedOfTunbridgeWells oh you are

ConcernedOfTunbridgeWells

@swasheck Irony level: Hipster.

billinkc

@swasheck Shhhh, I don't want to ruin my street cred of unhelpful and rube goldbergesque answers

JNK

3:47 PM

@swasheck it's running successfully is the problem

ConcernedOfTunbridgeWells

Could you deal with it as a process change like:
Have a separate master validation report that you run before bursting the reports out to the clients?

Then you can check that everything's OK before sending the reports to the clients

JNK

@ConcernedOfTunbridgeWells yeah potentially

I may just write a longer stp that pre-validates all the data in the subreports

these are quick since the numbers are mostly pre-crunched

ConcernedOfTunbridgeWells

@JNK Given that I don't think SSRS will do what you want out of the box - or at least I can't see a way to do it that isn't horrobly convoluted.

JNK

@ConcernedOfTunbridgeWells there's no vbscript method to check if records exist in a subreport?

ConcernedOfTunbridgeWells

@JNK Doesn't ring a bell.

JNK

3:54 PM

good enough, thanks!

sorry to divert the room everyone

swasheck

BACK TO THE REGULARLY-SCHEDULED NONSENSE!

billinkc

I like turtles!

ConcernedOfTunbridgeWells

@JNK However, I did see this in the course of my google-fu, which might do what you want.

4

Q: How to supress empty subreports in SSRS 2008

I'm creating a 'master' report in SSRS 2008 that collaborates other reports about a person. Sometimes not all of the other reports are relevant and as such return nothing. I'd like to be able to exclude this from the master report so it does not leave a blank page. I'm aware of the 'no-rows-mes...

reporting-services ssrs-2008 visibility ssrs-reports subreport

billinkc

I love that whoever has signed my spam catcher account up at least has interesting reading habits "Electrochemical Impedance Spectroscopy and its Applications"

JNK

@ConcernedOfTunbridgeWells mahvelous

ConcernedOfTunbridgeWells

4:08 PM

@JNK Think it will help?

JNK

very likely

I can probably use that IIF to throw an error

ConcernedOfTunbridgeWells

Jolly good. A useful answer off Stackoverflow no less. Who would have thought?

2

ypercube

@billinkc ?? spam cacther account?

billinkc

My gmail proper is my name, my spam catcher account is the one I use for registrations, marketing sign ups, etc. Basically, if people want to contact tenaciousb they're welcome to it

Mike Fal

Sometimes you need to spam them hard?

billinkc

4:15 PM

It's read only. I've sent less than 50 emails from it

James

4:45 PM

So, 'hard TSQL problems.'... I'm guessing this probably means things like recursion, gaps and islands, relational division?

billinkc

Or when the value is greater than 10

Aaron Bertrand

Anyone have a better guess?

0

A: SQL Server - Maintenance Plan Backup Database Task - What's the end of the filename?

Since this logic is buried within the code for the SSIS package behind maintenance plans, I think you will only get guesses unless the author happens to swing by here. Here is my educated guess based on a few experiments: For SQL Server 2008 and above, the 7 digits are the sub-second portion of ...

@Bill any clever ways to debug a package to determine how the "View T-SQL" is populated?

billinkc

Working on it

Have used the wizard to create package, pulling it down and seeing what it does

Mike Fal

5:01 PM

Meh, don't use maintenance plans. (yes, my bias is showing)

Aaron Bertrand

I don't either, and I often advocate against them. Too many "what does this button do?" checkboxes.

billinkc

Hmmmm it's encrypted and I didn't specify a password when the wizard created it

Ah, nevermind, there's an export option

swasheck

5:24 PM

maintenance plans seem more like something that mongo should have

billinkc

6:13 PM

The data wouldn't fit in a bigint, int, float so I thought why not use varchar(max) to hold 10 numbers?

-2

Q: XML file datatypes and sql equivalent for file import to sql

I am currently working on using SSIS to import a xml file into sql server. I am presently stuck defining my sql table destination data type where the xml source type is unsignedLong. I have searched the web and this site for a xml/sql data type equivalent chart to no avail. On the SQL side I have...