The Heap™ – Consultancy ©® - 2015-07-02

« first day (1640 days earlier) ← previous day next day → last day (3238 days later) »

6:01 AM

Is t-sql relevant for this question?

1

Q: connecting to a database via tsql on mac 10.10.4

I'm trying to connect to a database via tsql. I use the following command: TDSVER=8.0 tsql -S <server IP> -p 1433 -U <my username> -P <my password> Now, I know the server IP is correct because I can ping it. I also know the port is correct from tsql -LH. It tells me the tcp is 1433. However,...

sql-server t-sql connectivity osx

Also, oracle is likely irrelevant here

0

Q: sql query group by data of certain range in continuous date

I want to Write a sql to query group by data within a certain range in continuous date.I'm usig T-SQL. Table: Date | MeterNo| Data | ---------|---------|---------| 01-06-15 | 12345 | 10 | 02-06-15 | 12345 | 12 | 03-06-15 | 12345 | 51 | 04-06-15 | 12345 | 56 |...

sql oracle t-sql

but it probably doesn't matter because the question is a cross-post. The SO question

0

Q: sql query group by data of certain range in continuous date

I want to Write a sql to query group by data within a certain range in continuous date.I'm usig T-SQL. Table: Date | MeterNo| Data | ---------|---------|---------| 01-06-15 | 12345 | 10 | 02-06-15 | 12345 | 12 | 03-06-15 | 12345 | 51 | 04-06-15 | 12345 | 56 |...

was posted earlier and has answers.

2 hours later…

7:53 AM

@AndriyM not much, no.

3 hours later…

10:52 AM

guten Tag

someone with a better English than mine, which one is correct (or better if both):
- I have learned that I can do this and that
- I have learned that I could do this and that

I'd say they're both right, but let's wait for a native speaker

I wouldn't personally use 'this and that' in a sentence, but it depends on the context.

@MarkSinkinson well, that might also be a point, but I'm after can vs. could

BTW, what would you use instead?

@dezso guten tag Herr @dezso :)

how's your German adventure?

@Marian very fine, thanks

10:58 AM

@dezso To me they would communicate different levels of possibility (or perhaps different degrees of readiness on your part)

I am going to have lunch with a Syrian and two Brasilian colleagues

@AndriyM it turns out I cannot express myself

I learned I could do X - here could is mandatory, I think

now compare this to the present perfect use above

(I have to run away now but will check the results after lunch ;)

"Could" can be used in the future sense. So it probably depends on what you are trying to say

"could" implies possibility, "can" is an assertion of possibility. I can do SQL and I could learn to use MongoDB. I don't know MongoDB yet, but it is possible for me to learn.

But I recommend this:

@dezso To me, a present tense grammatical equivalent of that would be the "can" version.

@Gemtastic How about "We could use SQL here" vs "We can use SQL here"?

I feel they are different, I'm just not sure I could explain it.

@AndriyM "We could use SQL, but we aren't"

They are different. "Can" is an assertion of something now and present, "could" is a possibility but yet to be asserted.

11:10 AM

They are meant to be suggestions. To me the first one is basically a "less confident" version of the second one, as in "We could use SQL here, [but I'm not sure if that is a good idea". The second one I would use if I was sure it was a good idea.

Yes, "could" is predicting a possibility that has yet to happen or yet to be asserted. Can is not suggestive at all.

But "confidence" has nothing to do with it.

@Gemtastic Right, then I would be using English wrongly :) I've read on "can vs could" in the past but it's clear I haven't grasped all the nuances correctly.

The nuance is harder to explain than to understand to me. Could should be used in contexts like "I could make a query for that data if you want me to." (offering a possibility that has yet to be confirmed possible.) "I can write SQL queries that fix that issue" (I know how to do this hands down no issues)

:P

12:08 PM

hi all

hello ^^

I don't know half the people in this room anymore

12:25 PM

@Kermit oh yes, you do

it's not our fault you don't come here as often as you did

@ypercube gemtastic ? .. no one in here knows what vertica is.. except you

everyone knows "Vertica BOOM"

2

I too have been pretty bad about coming in recently

work just got crazy

user image

2

@Kermit Fresh blood

12:37 PM

@Gemtastic as long as you're not bleeding

Well..

wow @JNK is here ;P

Lots of SE mods :O

@bluefeet yeah sorry

the past month or two has been one of those times where I didn't even realize I stopped coming in

I just had no time to do anything but deal with work emergency stuff

It happens

12:50 PM

still sucks

glad to see you back

@bluefeet how's your new jo

oh yeah how is that

it's really good

1:07 PM

good to hear

1:24 PM

I love the days when I have so much work that I don't have time to log in to SO or SE

@Kermit hey, you are here

@Gemtastic i loved the days when i had so much work to do that i spent it on SO instead

@Lamak i amz

@Kermit XD

Well, I'm learning about MongoDB atm, but it seems not many people in here knows it

@Gemtastic sorry to hear

I feel insecure about the security

1:25 PM

@Gemtastic we know it's WebScale™

@Gemtastic oh, we know about it

I'll quote myself:

yesterday, by Gemtastic

Yeah, I prefer postgres to be honest, but this is what I'm being paid to learn now so I'm putting down all my effort into it ^_^

SQL is a lot easier to learn. It's not as herpaderp

Funny enough; the official documentation for mongoDB is about as fragmented as the database

And most tutorials don't even cover administration.

"It works without authentication so we'll just go with that"

@Gemtastic So, in a way, it's consistent with the database.

@AndriyM Yup.

Not to mention the official tutorials are online classes...

...which you have to attend in real time

How many have you attended already?

1:32 PM

They start in fall and I think that as a protest I won't attend

I'd rather just do trial and error until I figure it out.

I wish I was good at hacking so that I could try to hack my own applications to test security

@AndriyM ...eventually.

3

<rimshot.wav>

r..rimshot?

@Gemtastic Like this

You think I dare clicking that at work?

@Gemtastic I didn't think so because I didn't think :)

1:40 PM

we are pure, innocent people dude

You'll have to forgive me for not giving you the benefit of the doubt at work

I've been hurt too many times before I even managed to get a job

@Gemtastic rimshot is a thing a drummer does to punctuate a joke

a lot of times a BAD joke

which is common from @JNK

yeah

@JNK Well, that's ONE meaning

1:43 PM

phonetically: "BAH DUMP CHISH"

I know what it is. But I also know what some other people call "rimshot"

3 mins ago, by Lamak

we are pure, innocent people dude

even urban dictionary agrees with me

he's thinking where "shot = job" i believe

@AndriyM The last time someone told me that, they were VERY sarcastic :P

1:45 PM

@JNK thought of you and @mikefal while reading/reposting this

17 hours ago, by swasheck

> You are my best creative partner and we will build many more great projects together. And as far as I’m concerned, your special son PowerShell can live with us for as long as he needs, even indefinitely. Everyone around the shop loves him and knows he gets a lot done, in his own peculiar way; we just ask him to sit on a towel.

lol

@swasheck you are probably right

anywho ... i had to hop online so that i could troll some facebook folks before i left for work. now it's off to the races.

@swasheck What did you troll them with?

or about

@Lamak speaking of trolling facebook friends, many of them would consider me to be quite left for their tastes

@Gemtastic i'm not going to tell you the topic ... but i trolled them with their own medicine

1:50 PM

@swasheck Sounds like you had fun

l8ters t8ters and sk8ters and masterb ... nevermind

So innocent

;P

@swasheck which probably is still very right for everyone else's standards

2:18 PM

anyone know of food trucks in columbus, oh

2:38 PM

@Lamak could be

@Kermit my sis in law might, she lives there

@JNK i need to know in the next 20 min

@Kermit i'm sure SOMEone knows of one

streeteatscolumbus.com

ohiofoodtruckfinder.com/#columbus

2:40 PM

WTF. there are sites for that?

@JNK I see your googlefu has grown powerful during your absence

lol

I've been training!

working on my googlefu

heres a good list too on twitter

twitter.com/streeteatscbus/lists/street-eats-columbus

duckduckgofu

2 hours later…

4:46 PM

well i stand up next to a mountain

5:32 PM

And chop it down with the edge of my hand.

1 hour later…

6:43 PM

Excuse me while I kiss this guy.

Or the sky.

Or this police officer.

6:55 PM

chuu chuu~

7:08 PM

@MikeFal ... i'm struggling with a pretty simple issue ... is there a way to use a t-sql variable across multiple batches? i can't rely on sqlcmd mode

I don't believe so. You mean between GO, right?

ya

Stuff the value in a temp table at the beginning and use that?

yeah ... the problem is that i'm messing around with showplan_xml and it's killing me with having to be the only statement in the batch

8:05 PM

You can pass the variable between batches with scopes

Outer scope can see the variable and pass it to inner scopes

using sub-procs or dynsql

@JNK tell me more ... could you show me an example? i'm pretty dum

Well what are you trying to do with the variable?

just pass it IN but not change it and get it back?

set it at the beginning of the script for the sake the users. here's the pattern

(it's actually a query)

ok

assign query to variable

do some setup (XE/showplan_xml)

nevermind, though

i just remembered the other problem

8:20 PM

why

ok

set showplan_xml wont work in in one dynamic statement

has to be the only thing in the batch

oh its the SETTING

set showplan_xml

erg

you can still do it in dynsql I think

separate batches in one dynsql session?

nope nvm

dynsql won't use GO of course

natch

gist.github.com/swasheck/7acdc0619ca835b95ed7#file-sg2014-sql

8:31 PM

oh that's nice

does it work as-is?

uhhhh

fah

hang on

an in answer to your question I don't know of a way to pass that variable around

you can't use inner scopes there

yes

it works as-is

ok

I think you would have to save the variable to a real table most likely

erm. just made a quick update and now it should work

@JNK yeah. but still can't set the showplan_xml stuff

9:08 PM

If the variable doesn't need to be used as a stored procedure's argument, one workaround could be to use a view returning a constant value (the value you need to use across multiple batches).

The view would show in the plan but it would likely have a tiny impact on the query cost

Ah, sorry, it's a query that is stored in a variable...

9:42 PM

I'm voting to close this question as off-topic because it has been cross-posted at DBA.SE: dba.stackexchange.com/questions/105766/… One question, in one site, is enough. Please do not cross-post. @Kulbir, you are a member for almost 2 years, you should know that. — ypercube 3 mins ago

« first day (1640 days earlier) ← previous day next day → last day (3238 days later) »

Transcript for

Jul '152

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile