Viewing 15 posts - 976 through 990 (of 3,500 total)
Oh! I knew it had to be easier than I was making it!
April 29, 2019 at 4:52 pm
For grins, I wrote this in VB.NET (well, sort of)
Public Function FormattedDate (ByVal dtInputDate As Date, ByVal blnShort As Boolean) As String
Dim m As Byte
Dim...
April 27, 2019 at 6:40 am
From what I've read, Language is a report-wide setting. So the only way I could think of doing it is to use either SWITCH or a lookup.
I sort of got...
April 27, 2019 at 4:53 am
If these are EDI files, then you can't just import them. You have to parse those, because the different lines have different meanings/information. Do they have a consistent structure?
April 26, 2019 at 10:19 pm
the one upside to certification is that it may cover things you might otherwise miss. On the other hand, be aware that they don't cover everything. (Damned if you, damned...
April 26, 2019 at 10:15 pm
Depends on what you mean by "closest". If it doesn't matter if it's over or under, you could use
ABS(DATEDIFF(...))
April 26, 2019 at 6:41 pm
Why do you have 4 columns that, in theory, contain potential duplicates and lots of nulls? Either I'm missing something, or this is a nonsensical question.
April 23, 2019 at 12:28 am
Run this and try it again:
use master;
go
ALTER AUTHORIZATION ON DATABASE::AdventureWorksDW2016 TO [ComputerName\InstanceName];
April 22, 2019 at 6:52 am
I had a Visio license for 2000 version (it as a long time ago!) and it could reverse engineer databases. That would work, but it would be really nice to...
April 21, 2019 at 10:34 pm
Didn't Lowell Aguirre post something on using gmail for this? I think it was several years ago, but should still be applicable.
April 19, 2019 at 7:31 pm
(Why can't I edit my original response? Hmm...)
Here's the article:
https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-“csv-splitter”-function
SELECT test.SomeID, test.SomeValue, split.ItemNumber, Item = QUOTENAME(split.Item,'"')
FROM #JBMTest test
CROSS APPLY dbo.DelimitedSplit8k(test.SomeValue,',') split
WHERE split.ItemNumber = 4;
April 18, 2019 at 1:12 am
Use DelimitedSplit8K() and then specify the item# you want to return?
Jeff Moden wrote an article about splitting strings and included a UDF to do it. It returns (Value, Position) so...
April 18, 2019 at 12:21 am
Like this?
use tempdb;
GO
-- Now i want to order the KEY Column in products table
use tempdb;
GO
-- Now i want to order the KEY Column in products table
CREATE TABLE...
April 15, 2019 at 4:04 am
Can you post real table definitions (even partial)? It's impossible to answer your question with the current level of detail.
April 11, 2019 at 10:51 pm
Maybe this article will help.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
April 10, 2019 at 5:12 pm
Viewing 15 posts - 976 through 990 (of 3,500 total)