Garadin

Forum Replies Created

Viewing 15 posts - 271 through 285 (of 1,473 total)

RE: Beginner programmer... book suggestion

These are all great books.
http://www.amazon.co.uk/Microsoft-Server-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/ref=pd_sim_b_7
http://www.amazon.co.uk/Inside-Microsoft-SQL-Server-2008/dp/0735626030/ref=pd_sim_b_3
http://www.amazon.co.uk/Inside-Microsoft-Server-2008-Pro-Developer/dp/0735626022/ref=pd_sim_b_3
Don't mind the UK links, these should be available just about everywhere
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 21, 2010 at 10:30 am

#1137354
RE: OPENROWSET showing NULL for numbers

Thanks Hyung-Joo, very helpful information.
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 21, 2010 at 10:25 am

#1137353
RE: T-SQL: Why “It Depends”

Great article Bob. It couldn't have been easy to find examples that lined up so nicely to demonstrate your point. I'm guessing there are quite a few hours...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 16, 2010 at 8:33 am

#1134486
RE: Using Start and End dates to create a number of months column

Among several other things.
Honestly, it's one of the things that is 'cool', but I haven't figured out what a practical need would be for it yet. Here's the query...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 7:48 pm

#1129532
RE: Using Start and End dates to create a number of months column

Debbie Edwards (3/5/2010)
Its quite exciting to find out about a new bit of SQL 😀
Debbie
I'd agree with that completely. Had some fun playing with "GROUPING SETS" this morning myself...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 3:56 pm

#1129492
RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

My pleasure, and same to you.
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 3:20 pm

#1129485
RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

Yep, delete and not replace it with anything. I assumed this would be on an entity per entity basis, but if you don't care about the entities and only...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 2:27 pm

#1129468
RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

My turn for an oops. For whatever reason, when I was reading this last night it appeared that the %'s were all off based on the numbers and made...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 1:56 pm

#1129452
RE: Procedures involving two servers

How hard would it be to break these steps into agent job steps? I could be completely off base here, but usually when I see problems like this it is...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 10:48 am

#1129316
RE: Procedures involving two servers

The amount of data (both starting and the amount of data you need for your 'result' post processing) is a big factor here, but there's also the concept of doing...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 10:05 am

#1129288
RE: Procedures involving two servers

What triggers this procedure/process? Does it need to be run on user demand or can it be done as a periodic scheduled job?
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 9:29 am

#1129267
RE: Using Start and End dates to create a number of months column

Wasn't trying to be picky, if cross joins weren't also a real thing I wouldn't have said a word... I just know that my memory plays tricks on me sometimes...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 7:48 am

#1129180
RE: Using Start and End dates to create a number of months column

Debbie Edwards (3/5/2010)
Thanks all.
I have just used the query in my original SP instead of the ridiculously long one and it works a treat.
I hope at some point I will...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 5, 2010 at 7:40 am

#1129171
RE: SQL statement to find what's missing...

Something to keep in mind when using NOT IN:
http://www.sqlservercentral.com/blogs/never_say_never/archive/2010/01/28/in-and-not-in.aspx
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 4, 2010 at 11:39 pm

#1128985
RE: Calculations error: aggregate may not appear in the set list of an UPDATE statement

I went ahead and debugged this, you can run the whole statement. Note a few things.
1. Your sample data doesn't match your results, things like the workingdayofmonth doesn't...
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

March 4, 2010 at 4:26 pm

#1128865

Viewing 15 posts - 271 through 285 (of 1,473 total)