Topics
Started by
Posts
Last post
I have a simple query like this: SELECT Count(DISTINCT(ProcessID)) As ProcessCount, Substring(Ca…
5 replies
Hi Ive got piece of sql that selects a list fo client ids from a table using a cursor and then del…
5 replies
By: Garadin
I have a scalar function to return a calculated value. In my table I have a column named LONG_FORMU…
15 replies
By: sgmunson
Hi Experts, I have read so many documents and articles about tempdb and its size. But all those doc…
10 replies
I have an UPDATE STATEMENT with a FROM CLAUSE, and i am using variables to capture the value and us…
20 replies
Hello, I have the following table: tempTable Id TmePeriod …
2 replies
We have in our system a table that contains a Free Text field containing Conditional logic (not sur…
6 replies
I am trying to simulate an array within a stored procedure by passing in a large group of values li…
3 replies
Hi i'd like to create a new folder in TSQL the folder name should look like WK## where ## is the w…
4 replies
Hi All, I read the above topics on wikipedia. It is very interesting...But i got struck in some pla…
2 replies
Hi All, Why is the following commented out code is returning Divide by zero error encountered b…
26 replies
By: Sergiy
Hi I want to set my database property to return a decimal number when I do division . e'g select 1/…
2 replies
By: Ronald H
I have two Tables Citation(CitationID, Date , ISReportTaken) and ReportExport(CitationID, Applicati…
5 replies
Morning gang, I'm trying to find members who were enrolled in a continuous manner, only one gap in…
6 replies
By: Garadin
I have an ARRAY problem like this: I receive a string consisting of sets of 3 values belonging toge…
2 replies
Viewing 15 topics - 2,206 through 2,220 (of 17,082 total)
You must be logged in to create new topics.