Topics
Started by
Posts
Last post
Hello, I have been trying and failing for days to create a query, or SSRS report, that makes a colu…
4 replies
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, [Item1]…
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 V…
5 replies
I need to convert column warehouse to Wh1 and Wh2 with the corresponding on hand select DATE…
2 replies
Sorry for the dumb question in advance. So I just bought a SQL 2014 standard license from a vendor,…
1 replies
Is it possible to create a temp table when setting a query? For example: DECLARE @Category varc…
2 replies
Viewing 15 topics - 91 through 105 (of 3,067 total)
You must be logged in to create new topics.