Topics
Started by
Posts
Last post
so I have the following problem. I have three tables in my postgresql DB. They are: package, cartyp…
15 replies
Hello Everyone, The below code is giving me error:Msg 3623, Level 16, State 1, Line 27An invalid fl…
44 replies
Dear All, i would like to create the virtual column result with if exist condition. Example&n…
6 replies
SELECT x.pkproductid ,x.supplierbarcodecorrect …
10 replies
hi all, i want to make faster e more elegant a procedure, if possible transorm into a single query.…
2 replies
select Country, Contacttitle, COUNT(ContactTitle) as Count,CASE WHEN GROUPING_ID() = 0 THEN ''WHEN …
3 replies
I have the following columns and there are 807k rows in all so this is just example: Line of Busine…
3 replies
I have created a package for our company that takes all the data from a table in our ERP production…
12 replies
I have the following CodeINSERT INTO dbo.Region (RegionID, RegionDescription)VALUES (5, 'Space') se…
3 replies
How can I convert the result into a DATE datatype as '0001-01-01' isn't supported with DATETIME? I'…
40 replies
I have the following table format: need to convert this table to following format: I looked for PIV…
5 replies
Hi there, I would like to automate deployment of my Visual Studio SQL Project to some environments.…
6 replies
I have table where an event has a start date and end date. An event might not have a end date sugge…
11 replies
I have a table which have values like this id date1 2018-07-162 2018-07-18…
16 replies
Hi All, I'm not good at SQL at all (self-taught), and could use your help. I have the following que…
7 replies
Viewing 15 topics - 1,306 through 1,320 (of 1,539 total)
You must be logged in to create new topics.