Topics
Started by
Posts
Last post
Hi everybody, i have a table in SQl Server 2014 like the following: And i woul like to abtain an o…
2 replies
Hello, I have been trying and failing for days to create a query, or SSRS report, that makes a colu…
4 replies
By: MacNiner
I am familiar with T-SQL's Pivot Operator, I've used it to convert rows of financial data into colu…
5 replies
how can I achieve this result below? | id | id_status | rate  | | --- | ----------- | ------…
23 replies
assume i have 2 tables CREATE TABLE #Setup ([PPHProfileNo] INT, [%DPP] MONEY, RangeFrom MONEY, Rang…
2 replies
Hi Is it possible to create Temp table according to Pivot output dynamically & show Grand Total…
11 replies
Hi I want if multiple records are returned by inner query then Docno of all records should get conc…
3 replies
Hi How to display Totals in the end declare @cols as nvarchar(max)=''; declare @query as nvarchar(m…
1 replies
Hi select T0.num,T0.doc,T0.CCode, (stuff((select cast(', ' + convert(varchar(max),A0.doc)…
1 replies
Hi ​  I am getting below error. Msg 203, Level 16, State 2, Line 20 The name 'select Name, [It…
1 replies
I just bought a SQL 2014 standard license from a vendor, but noticed that the product key can be lo…
1 replies
Hi All Trying to do a query to find out how old are the cpu on device. We do have a way of doing it…
6 replies
Hi I have the sample table here CREATE TABLEÂ Game (id int, Game_Time datetime ) INSERT INTO Game …
5 replies
Does anyone know of an "AdventureWorks-esque" sample database for the heatlhcare, health insurance …
14 replies
I need to convert column warehouse to Wh1 and Wh2 with the corresponding on hand select DATE…
2 replies
Viewing 15 topics - 1 through 15 (of 2,985 total)
You must be logged in to create new topics.