Viewing 15 posts - 5,041 through 5,055 (of 14,953 total)
Stefan Krzywicki (2/9/2011)
GSquared (2/9/2011)That and the thread on "Where do you find DBAs" have made me wonder more about how managers pick DBAs. I know how I would, were...
February 9, 2011 at 11:15 am
Stefan Krzywicki (2/9/2011)
Brandie Tarvin (2/9/2011)
Jan Van der Eecken (2/9/2011)
February 9, 2011 at 10:48 am
Tom.Thomson (2/9/2011)
Grant Fritchey (2/9/2011)
Sorry guys, I'm not going into that one. It smacks of "Someone is wrong on the internet" I'm sure I can spend my time elsewhere more...
February 9, 2011 at 10:43 am
The answers to all of those questions are highly dependent on your specific business needs and resources.
Really, I'd hire a contractor to help you plan it all out. That...
February 9, 2011 at 8:56 am
What are you looking for?
You design SSIS packages in Business Intelligence Development Studio, or .NET Studio, or other related tools.
You manage the packages being run as jobs from Management Studio...
February 9, 2011 at 8:54 am
There are a lot of options, depending on what you want to do with the exact data.
Most importantly, why insert automatically into Orders just because you add to Customers? ...
February 9, 2011 at 8:52 am
Craig Farrell (2/8/2011)
*sighs* I've failed sainthood. I leave this gentleman in your hands, he can't even debate well, and my patience is stretching to the unprofessional realms.http://www.sqlservercentral.com/Forums/Topic1059167-145-1.aspx
It's not so...
February 9, 2011 at 8:32 am
I'd go with Jack's design. Don't bother with denormalizing the expiration or last payment date into the users table. Just query the payments table to get that.
If you...
February 9, 2011 at 8:20 am
nadabadan (2/8/2011)
Not entirely sure why you're up in arms over this one, nadabadan. It might just be the way I'm reading your writing style. Either way:
The only reason...
February 9, 2011 at 8:06 am
nadabadan (2/8/2011)
GSquared (2/8/2011)
nadabadan (2/8/2011)
GSquared (2/7/2011)
nzngh (2/6/2011)
February 9, 2011 at 7:56 am
ColdCoffee (2/9/2011)
Gus, i think, you have missed adding Version column to your inner select.
The original request didn't include the version number in the results. I try to match the...
February 9, 2011 at 7:25 am
You can bypass the table variable step if you specify the columns in Tbl5 in the Output clause.
OUTPUT inserted.MyCol INTO dbo.Tbl5(Tbl5Col)
You can list the columns you want to insert into...
February 9, 2011 at 7:21 am
Jeff Moden (2/8/2011)
Brandie Tarvin (2/8/2011)
proper American EnglishAccording to some of my British friends, that's an oxymoron. 😛
Calling Prof Higgins ...
February 9, 2011 at 7:12 am
This should get you started:
;
WITH RefNos(RefNo)
AS (SELECT DISTINCT
...
February 9, 2011 at 7:07 am
I'd say building something in Access (or .NET, even better) is probably your best option.
Most databases are designed to be accessed via a specific application, set of applications, or SAS...
February 9, 2011 at 6:18 am
Viewing 15 posts - 5,041 through 5,055 (of 14,953 total)