Topics
Started by
Posts
Last post
assume i have 2 tables CREATE TABLE #Setup ([PPHProfileNo] INT, [%DPP] MONEY, RangeFrom MONEY, Rang…
3 replies
If I have a query with multiple UNION ALLs, will the optimizer try and grab enough memory to run al…
7 replies
Hi all, I have been using FORMAT() FORMAT(Tab.date, 'yyyy-MM-dd') AS 'date_begin', but been told it…
22 replies
Hi All, I have spent a few hours after revisiting this serval times and have never come up with a w…
2 replies
Hello friends, I have a requirement where I have to compare the two fields using regular expression…
6 replies
I am running SSIS >> Execute SQL task with Direct sql Statement , connected to MySQL via ADO.…
8 replies
Hi, I'm converting Oracle Queries into MS SQL and there are fucntions which are specific only to Or…
6 replies
Hello. I am not a SQL Developer - just an IT generalist (if that) who dips in and out of SQL Server…
18 replies
I've been a DBA for 12+ years, and while interesting, I feel I'm starting to stagnate. I saw this a…
2 replies
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
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
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
Viewing 15 topics - 1 through 15 (of 2,992 total)
You must be logged in to create new topics.