Viewing 15 posts - 8,716 through 8,730 (of 8,731 total)
We just made a similar script but focusing on the columns and not using the schemas (as they don't use them in here).
But because we're not dbas and we don't...
July 2, 2012 at 10:04 am
SQLKnowItAll (6/28/2012)
Luis Cazares (6/28/2012)
SELECT DISTINCT y.*
FROM Table x
CROSS APPLY (SELECT TOP 3 * FROM Table y...
June 28, 2012 at 1:06 pm
Will something like this apply? (I'm learning how to use CROSS APPLY :blush: )
SELECT DISTINCT y.*
FROM Table x
CROSS APPLY (SELECT TOP 3 * FROM Table y WHERE x.id =...
June 28, 2012 at 12:56 pm
Do you intend to show the first 3 values on SysCC for every ID?
June 28, 2012 at 12:50 pm
I was tempted with the first answer as it seemed correct. But a little bit of logic indicated me that there's no reason for the database backups to be incomplete...
June 28, 2012 at 7:40 am
As okbangas said, hex is used to represent the information. Your looking at the same thing:
a = 01100001 (binary) = 61 (hex) = 97 (decimal)
So you're looking at the binary...
June 26, 2012 at 7:57 am
My mistake, I meant ORDER BY.
June 19, 2012 at 7:00 pm
peacesells (6/16/2012)
balasach82 (6/16/2012)
Like ...
SELECT F1, F2, F3...
June 19, 2012 at 3:03 pm
If your columns behave as bit columns instead of behaving as int, there's no need for the case, you can simply add the columns.
June 5, 2012 at 7:00 am
For instance, there's no reason to use a JOIN if you use fields from one table. Instead of doing this:
SELECT P.PodrobnostiAutoID
FROM dbo.vwPodrobnosti P
LEFT JOIN dbo.vwTableOfGenuss G ON P.GenusAutoID =...
June 4, 2012 at 1:31 pm
anthony.green (6/1/2012)
F6 will cycle through the query panel, results panel, messages panel if thats what you want.
Shift + F6 will go in the opposite order.
June 1, 2012 at 8:12 am
There can be a small problem with Jeffem and ColdCoffee's solution.
If you miss an ID value (most common scenario is when you delete a record and the identity does...
May 31, 2012 at 3:27 pm
It sure was an easy question and a fact anyone using WHERE clauses should know. The difficulty is on understanding the question and reading carefully.
I got it wrong because I...
May 31, 2012 at 2:55 pm
Thank you Paul and Celko, I appreciate the effort and time you made on answering this going even with more details.
I didn't beleive that DDL would be necessary as the...
May 22, 2012 at 9:15 pm
This could help you.
DECLARE@nDate1int,
@nDate2int,
@dTodaydatetime
SET@dToday = GETDATE()
SET@nDate1 = DATEPART( y, @dToday)
SET@nDate2 = DATEPART( y, DATEADD( ww, 2, @dToday))
IF @nDate2 < @nDate1
BEGIN
SET @nDate2 = DATEPART( y, CAST( YEAR( @dToday) AS char(4)) +...
February 15, 2010 at 9:15 am
Viewing 15 posts - 8,716 through 8,730 (of 8,731 total)