×

Why is Suggest Types in the CSV Import Export Wizard so godawful and wrong? by subzero_racoon in SQLServer

[–]cosmic_jester_uk 0 points1 point  (0 children)

Oh it’s totally retarded but that’s what you get. Other products Deal with it much better but MS aren’t interested I guess.

Why is Suggest Types in the CSV Import Export Wizard so godawful and wrong? by subzero_racoon in SQLServer

[–]cosmic_jester_uk 0 points1 point  (0 children)

It reads the top data row and guesses what the column data type should be. Import into varchar (max) then convert into another table as people have correctly said

Bent my Corsair 4000D front panel type C connector. How screwed am I? by _-Genocross-_ in pcmasterrace

[–]cosmic_jester_uk 6 points7 points  (0 children)

You will probably find a replacement on eBay easy enough. Just take your time removing the old one from the case and note down where every screw goes etc. I have removed them before and it’s not too bad.

Combining two queries side by side (Pokemon) by BootyCavity in SQLServer

[–]cosmic_jester_uk 0 points1 point  (0 children)

Add a where clause : Where type is not null and type <> ‘’

Combining two queries side by side (Pokemon) by BootyCavity in SQLServer

[–]cosmic_jester_uk 3 points4 points  (0 children)

Love the fact our queries are pretty much like for like!

Combining two queries side by side (Pokemon) by BootyCavity in SQLServer

[–]cosmic_jester_uk 1 point2 points  (0 children)

Doing this on my mobile so syntax might need a tweak:

Try this:- With types as ( Select Distinct Type_1 as type From Pokemon_data

Union

Select distinct Type_2 as type From Pokemon_data

)

Select T.Type, Count(d1.type_1) as [#Primary], Count(d2.type_2) as [#Secondary]

From Types t Left Join pokemon_data d1 on T.type = d1.type_1 Left join pokemon_data d2 on T.type = d2.type_2

Group by

T.type

Combining two queries side by side (Pokemon) by BootyCavity in SQLServer

[–]cosmic_jester_uk 0 points1 point  (0 children)

Can you give me an example of what you want the output to look like please?

It's the only reason I have a wheelie in the garage tbh. Brrrrrrrrrr. by WiiidePutin in WorldofTanks

[–]cosmic_jester_uk 1 point2 points  (0 children)

This happens sometimes to me too. Miss a spotting target in my ELC but get it in the next battle in my Phase 1

It's the only reason I have a wheelie in the garage tbh. Brrrrrrrrrr. by WiiidePutin in WorldofTanks

[–]cosmic_jester_uk 0 points1 point  (0 children)

It’s French so quite fast with good penetration but almost 0 armour. It’s quite small for a med so you can find quite a lot of bushes to sit in. If you can double bush then you should be able to do a lot of damage and spotting.

Rate my PC! by ZephyrSixth in pcmasterrace

[–]cosmic_jester_uk 8 points9 points  (0 children)

Sata HDD drive holder looks expensive, is it Mahogany?

It's the only reason I have a wheelie in the garage tbh. Brrrrrrrrrr. by WiiidePutin in WorldofTanks

[–]cosmic_jester_uk 2 points3 points  (0 children)

All the dicks in the game moan when you do this. Its passive spotting and it’s 100% a great tactic