Topics
Started by
Posts
Last post
i have somthing strnage. when i run this command in mssql insert into [LinkedSRV]...[xfer_in_order…
3 replies
Hi, I've an orders table with customer and supplier (customer_id, supplier_id, order_id, order_date…
7 replies
Does anyone know if there's any way you can determine if a column in a table is used or not? I have…
17 replies
i have a question, below query doesn't return any data. application is allowing filters on same col…
3 replies
Hi - I'm looking for a code parser for SQL Server 2014 - ie something that I can point at a sproc o…
6 replies
Hi Team, Want to create a view using below query, and also want to apply indexes on that view. SE…
8 replies
Hello all, I have a table that I need to split up the records into multiple records by and Integer …
12 replies
We have a heavily used GUI that displays specific business data in a pivot. A stored procedure is u…
3 replies
Hi, When we update/insert any table how do we know which other tables are effected in sql server? I…
3 replies
I've been trying to use dynamic unpivot and pivot (thanks to some code examples from someone named …
7 replies
I was recently trying to optimize a big SQL statement (a dozen of JOINs and APPLYs), commenting som…
7 replies
I have declare @t datetime = '2016-11-02 07:22:26.320' SELECT LEFT(CAST(REPLACE(CONVERT(VARCHAR, …
7 replies
Dear All, I am trying to bring the group total .below my query, WITH Prep AS (SELECT preffered_name…
14 replies
I have two tables and I have to merge the records. source: ID seq name designation company 0…
4 replies
Hi Guys, I've got a bit of a query problem that I am not quite getting where to start, to be honest…
8 replies
Viewing 15 topics - 1,756 through 1,770 (of 3,067 total)
You must be logged in to create new topics.