Topics
Started by
Posts
Last post
I stumbled upon this function in T-sql and couldn't find any documentation for it. The select state…
5 replies
Hi, I have following table structure, CREATE TABLE [ModulePermission] ( [Mo…
9 replies
Hi gurus, Is there any way of creating a SP from a SP https://dbfriend.blogspot.com/
3 replies
Hi all, I've got this query as seen below, now it needs to grab distinct rows where the user is dis…
1 replies
I am consolidating 4 comment fields into one note field (Record_Notes which is a text field). I wou…
4 replies
Hello. Looking into the Trigger BOL help I realized into one example that uses @@VarName CREATE TRI…
3 replies
Hi all, I keep slamming into the wall on this one. I am trying to combine the data from the source …
4 replies
Hello, I need to pass table names as variables to a stored procedure. I keep getting this error: Se…
4 replies
Hi everyone, We have sql server 2000 and the execution time for the last query is suprising me…
11 replies
My question is about statement control within a script. It's very convenient to have all the …
2 replies
Is there any way on a non-case-sensitive SQL Server, to do a "Select Distinct..." which will bring …
10 replies
Hi I am new to T-SQL and can do stuff in asp but now need to use jobs to change data at set times, …
26 replies
Hello Here's a challange 😉 The following query: select count(*) from Table_T returns 3804039 select…
12 replies
Hi All I have a server with 6 processors and 8 gig of ram. I also have 2 tables, ah and sd ah has 2…
4 replies
Hi All, I'm trying to find the function Trimmean to be used in a query but it has been a …
11 replies
Viewing 15 topics - 11,446 through 11,460 (of 17,082 total)
You must be logged in to create new topics.