Topics
Started by
Posts
Last post
I have the following query which works well except for 1 issue WITH T1 As ( SELECT DateTime, TagNa…
5 replies
Hello comunity I found a code snippet that use the curious following sintax on the creation of View…
7 replies
Hi Team, using below script to compare two tables and get the values. how to get the count of 'Tabl…
1 replies
Im trying to select leveling; I have table like this; FACC_WID FACC_BKEY FACC_CO…
1 replies
In a t-sql 2012 select statement, I have a query that looks like the following: SELECT CAST(ROUND(…
3 replies
Hello, I'm trying to convert the query immediately below into a function with the conditional logic…
6 replies
Hi, I am tuning the following CPU intensive query, which is also a remote query for a given store p…
22 replies
This is not working. select * from INFORMATION_SCHEMA.ROUTINES where routine_type in( 'PROCEDURE' …
1 replies
EDIT How in the heck did I mark my question as the answer!!!! Eirikur's answer is what helped me. …
3 replies
I wish my transform variable, so that adding the OR operator, and the words within the quotes are n…
8 replies
Hi I have a temp table shown as the following. CREATE TABLE #Table1 (ID INT IDENTITY(1,1), Person i…
9 replies
I have a column A as 'text' datatype. This has CR-LF in between data. How to remove it. I am trying…
2 replies
Is there a way to generate report of how many server alias exist on a server. I try to extract usin…
2 replies
I got this query from a tuning book and it does not run in 2012. I believe the issue is in the sub…
2 replies
SQL Server 2012 SP2 Enterprise Edition (11.0.5058.0) on Windows Server 2008 R2 At some point a few …
9 replies
Viewing 15 topics - 3,196 through 3,210 (of 4,984 total)
You must be logged in to create new topics.