Topics
Started by
Posts
Last post
Hi all, I have been using FORMAT() FORMAT(Tab.date, 'yyyy-MM-dd') AS 'date_begin', but been told it…
33 replies
I need to update a report to show the month name in the specific language - creole. I use the funct…
5 replies
hello, I want to monitor the odbc connections. In table sys.dm_exec_sessions I find all actually op…
2 replies
If I have a query with multiple UNION ALLs, will the optimizer try and grab enough memory to run al…
8 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
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
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
Viewing 15 topics - 76 through 90 (of 3,062 total)
You must be logged in to create new topics.