Topics
Started by
Posts
Last post
Hi, I'm trying to find out whether is possible to achieve the following with a procedure. Let's say…
2 replies
Ahoi, so far i have only been using TSQL and MDX to solve my problems. I know it is possible to run…
3 replies
i am trying to sort out a recursive CTE that expands a bill of Materials. I am trying to get just t…
17 replies
Hello Trying to convert an Oracle SQL which uses "partition" in Left outer join into SQL server as …
4 replies
Firstly apologises as I suspect I'm missing the obvious somewhere. I can query other XML files succ…
3 replies
I am using the following query to remove the IDENTITY in tables where data already exists. This que…
1 replies
SELECT 'Per Category' AS Category, [1], [2], [3], [4], [5], [6], [7], [8] FROM (SELECT Categ…
22 replies
Hi I have this query using PIVOT SELECT * FROM ( SELECT a.Mun, l.Name, a.NumberOfRooms FROM Acco as…
2 replies
Dear, I have created a SQL Server agent job on SQL 2017 server. I have the output of the query to t…
18 replies
Hi, I am trying to create a query for gap analysis when country value do not match based on followi…
9 replies
Good morning all , I use the row_number function to retrieve my contracts I would like to display o…
4 replies
Last night, my company tried deploying a large update to almost all tables & sp's to our produc…
2 replies
I have an xml field [Risultato] in a Table , the first record is like this: <RisultatiCalcolo …
2 replies
Can anyone help me out here. I need to convert strings in a file I received to datetime. An examp…
3 replies
All, My code is as follows: declare @xml xml declare @filename varchar(255) declare @bulkcommand nv…
5 replies
Viewing 15 topics - 466 through 480 (of 1,544 total)
You must be logged in to create new topics.