Viewing 15 posts - 2,341 through 2,355 (of 8,731 total)
Grumpy DBA (8/9/2016)
ThomasRushton (8/9/2016)
Ed Wagner (8/9/2016)
Entanglementhairball
* Cough *
Sneeze
August 9, 2016 at 7:23 am
pietlinden (8/8/2016)
Use the [Google]Force, young Jedi!
Use the tags, and you might be considered to enter the Jedi Council. 😀
August 8, 2016 at 2:36 pm
In the Parameter window, go to the "Default Values" tab and select "Get values from a query", then use the same dataset and value field as the ones defined in...
August 8, 2016 at 2:34 pm
Ed Wagner (8/8/2016)
Hugo Kornelis (8/8/2016)
Ed Wagner (8/8/2016)
whereisSQL? (8/8/2016)
Ray K (8/8/2016)
Ed Wagner (8/8/2016)
SwingJazz
Trumpet
Trombone
Seventy-Six
1776
1984
August 8, 2016 at 2:20 pm
skippyV (8/8/2016)
August 8, 2016 at 10:40 am
Revenant (8/8/2016)
djj (8/8/2016)
Sergiy (8/8/2016)
Grumpy DBA (8/8/2016)
Ed Wagner (8/8/2016)
Hugo Kornelis (8/7/2016)
SQLRNNR (8/7/2016)
ragequit
Resign
Celebrate
life
Death
Loss
Win
August 8, 2016 at 9:09 am
This seems like a weird design. Why would you have a transaction table for master product and master locations when you're supposed to be able to get them through your...
August 8, 2016 at 8:10 am
And now you have 2 threads with the same question and very similar answers. You only divided the replies and confused people on what version you're using.
http://www.sqlservercentral.com/Forums/Topic1807873-3412-1.aspx
August 8, 2016 at 7:55 am
Here's a possibility using an inline table function for this.
CREATE TABLE TestSplitData
(
Start DATETIME
,EndDt DATETIME
,Amount INT
)
GO
--Insert Data
INSERT INTO TestSplitData(Start,EndDt,Amount)
VALUES
('20140414','20141013',200),
('15-May-14','16-Jun-14',320)
GO
CREATE FUNCTION SplitDatesInMonths(
@StartDt datetime = '20140414',
...
August 8, 2016 at 7:18 am
I'm sure that you have some ID for each person that would work as a primary key. That's the reason I added it to the example.
You just need to unpivot...
August 8, 2016 at 6:40 am
JTSash (8/5/2016)
Your code works. I shall have to see about extrapolating it to my actual data. I will agree that the original data structure is flawed but it's...
August 5, 2016 at 12:46 pm
Jeff Moden (8/5/2016)
shanalalkasim (8/5/2016)
Hi,I have 7+ yr experience in Gupta SQL. It's entirely different from SQL server. If you need any help please contact me. My mail id is shanalalkasim@gmail.com
The...
August 5, 2016 at 12:03 pm
There's probably a better way to get this working without having to read the table 3 times.
I'd be interested on the loop as it could be faster than some options...
August 5, 2016 at 11:58 am
jasona.work (8/5/2016)
SQLRNNR (8/5/2016)
jasona.work (8/5/2016)
Movie review of the new Bourne movie (kept short)
Pros: Decent enough typical action movie.
Cons: Oh god the mangling and mis-use of techie!...
August 5, 2016 at 10:52 am
djj (8/5/2016)
Brandie Tarvin (8/5/2016)
So I'm importing my outlook...
August 5, 2016 at 6:45 am
Viewing 15 posts - 2,341 through 2,355 (of 8,731 total)