Viewing 15 posts - 4,291 through 4,305 (of 8,731 total)
tnpich (9/2/2015)
My SQL skills are not much past the...
September 2, 2015 at 9:48 am
Sean Lange (9/2/2015)
BrainDonor (9/1/2015)
What's the difference between 'None of the above' and 'Other'?Also curious what is the difference between "Development" and "Development DBA".
I understand it as coder and debugger. 😀
Well,...
September 2, 2015 at 7:32 am
Yet another option 😀
SELECT LEFT( Filename, Start.Bytes - 1) AS theFilename,
SUBSTRING(Filename, Start.Bytes + 7, Start.Records - Start.Bytes - 7) AS Bytes,
...
September 2, 2015 at 7:25 am
Here's an example on how to do it dynamic. It's not that complicated and it could become a stored procedure on itself.
DECLARE @LastName nvarchar(100) = 'Tamburello',
@FirstName...
September 1, 2015 at 2:23 pm
You can do it with the bcp utility by using xp_cmdshell or SSIS or Powershell.
September 1, 2015 at 12:46 pm
Even with large tables, NOLOCK hints aren't the best option. I'd suggest you to read more about this hint and understand how this is a poor idea.
Back to the original...
September 1, 2015 at 12:39 pm
A CASE statement can only return one data type. If possible, it will implicitly convert the values following the data type precedence rules. In this case, the empty string is...
September 1, 2015 at 10:20 am
Vladan (9/1/2015)
September 1, 2015 at 9:01 am
denis.gendera (9/1/2015)
pgroup ...
September 1, 2015 at 8:58 am
A bit simpler:
SELECT
t5.pgroup,
CONVERT(NUMERIC(5,2),SUM(CASE WHEN t6.state = 'INSTALLED' THEN 100. END) / COUNT(*)) AS INSTALLED,
CONVERT(NUMERIC(5,2),SUM(CASE WHEN t6.state =...
September 1, 2015 at 8:43 am
Another option is to change only the dateformat, or the condition (which can be painful to get it completely right).
SET dateformat dmy;
CREATE TABLE #TestDates(
UserField1 char(8));
INSERT INTO...
September 1, 2015 at 7:39 am
whereisSQL? (8/31/2015)
djj (8/31/2015)
Ed Wagner (8/28/2015)
whereisSQL? (8/28/2015)
Luis Cazares (8/28/2015)
Ed Wagner (8/28/2015)
DonlSimpson (8/28/2015)
SQLRNNR (8/28/2015)
'tater saladRon White
White Potatoes
black beans
Burrito
Steak
Cow
Milk
Chocolate
August 31, 2015 at 12:46 pm
Brandie Tarvin (8/31/2015)
I am planning to upgrade at least one of my machines. Haven't decided if it'll be the 8.1 or 7. But I'm waiting to hear feed back from...
August 31, 2015 at 7:00 am
This can help you, but it could give you false positives. I'm using sys.sql_modules, but you can use your table.
SELECT *
FROM sys.tables t
WHERE EXISTS( SELECT * FROM sys.sql_modules m WHERE...
August 28, 2015 at 2:09 pm
Do you need a select?
I started to work on an update, but it might give you an idea.
CREATE TABLE #Order(
OrderID ...
August 28, 2015 at 1:56 pm
Viewing 15 posts - 4,291 through 4,305 (of 8,731 total)