Viewing 15 posts - 1,381 through 1,395 (of 13,879 total)
Hello and welcome to the forum. As your question relates to spreadsheets (Google Sheets?) rather than SQL Server, which is the subject of this forum, this may not be the...
June 18, 2022 at 4:17 pm
That looks more like a C# error than a SQL issue.
A brief Google search suggested this.
June 17, 2022 at 10:57 am
This link gives a few reasons for choosing shorter varchar lengths.
In terms of storage, CHAR(n) columns are always n characters long.
VARCHAR(n) columns are anything between 2 and (n +...
June 17, 2022 at 9:09 am
Datatypes look OK, except for one. Remember to size your VARCHARs to be the maximum expected length of the data they will hold.
You're probably better off using CHAR(3) for CPZ...
June 17, 2022 at 7:37 am
I suspect your GROUP BY is causing the issue. Try changing it to
GROUP BY TLD.location_id, TP.Location
June 17, 2022 at 7:31 am
Alternatively, I think modifying the default collation on your database before creating tables and adding data to them should also do the trick (and then you'll be able to write...
June 15, 2022 at 1:46 pm
And that leads us to something like this:
SELECT *
FROM #temp
WHERE idaisl COLLATE SQL_EBCDIC037_CP1_CS_AS
BETWEEN basil COLLATE SQL_EBCDIC037_CP1_CS_AS AND eaisl COLLATE SQL_EBCDIC037_CP1_CS_AS;
June 15, 2022 at 1:41 pm
My fault, I should have been more specific. The steps outlined above are assuming I know what the model will look (so after I've done the normalization on paper)....
June 15, 2022 at 12:29 pm
If you can explain the requirement in English, I'm sure that someone here will help with the T-SQL.
It would also be useful to know the datatype of tab.x.
June 15, 2022 at 10:04 am
i tried this
https://www.mytecbits.com/microsoft/sql-server/auto-generate-insert-statements
And that works. But not incrementally.
June 13, 2022 at 4:14 pm
So you want a process which compares what is in a database table with what is contained in a flat file and which then modifies the flat file to reflect...
June 13, 2022 at 3:52 pm
I don't understand. When you restore from a backup it includes all the data from the backup. SQL Server does not do incremental backups.
June 13, 2022 at 3:26 pm
The one big downside though is passing a multi-valued parameter to the stored procedure. IIRC - don't use SSRS now - it has to be passed as a single...
June 13, 2022 at 12:22 pm
Try this:
INSERT #partsfeature
(
PartId
,FeatureName
,FeatureValue
,PartFeatureNumber
)
SELECT s.PartId
,s.FeatureName
...
June 12, 2022 at 1:33 pm
Viewing 15 posts - 1,381 through 1,395 (of 13,879 total)