Topics
Started by
Posts
Last post
So after spending some time rewriting a routine that used Cursors to use While loops, I am having t…
14 replies
Hi there, I have the following SQL code SELECT TEN.[tenancy-ref] AS 'Tenancy Reference' ,CAS…
3 replies
I am copying data from an inner join condition to select only applicable data for an external custo…
4 replies
I'm trying to find values in our account table where the account names are similiar. I've already …
3 replies
I have a table that stores dates of records that need to be reprocessed. Normally I would use MIN f…
1 replies
CREATE PROCEDURE USP_UPDATESAL @DPID INT AS BEGIN DECLARE @DPTID INT, @SAL1 MONEY SET @DPTID=(SELEC…
3 replies
I have a question for those who might know the answer. Here's the query in question - server.mydb.d…
2 replies
I have a table called 'tracking' with two columns 'CollectionUrl' and 'LastAccessedDate'. I would l…
2 replies
DECLARE @vFrDate INT,@vToDate INT DECLARE @DQDates INT DECLARE @Selection BIT,@Selection1 BIT,@Sele…
1 replies
Hi all! I am new to all this SQL malarkey, but i am learning it fairly quickly. I have managed to p…
6 replies
Need help on this one guys and girls, I manage to create a SQL statement for daily, weekly and mont…
13 replies
I need to create a stored procedure or query that will dynamically create columns from data in a co…
7 replies
Hi all, I have some code written by a developer who no longer works here, and they often use a star…
4 replies
Greetings all. Its been a while since I have had to make any reports, but lately the TSQL is back …
3 replies
Hello, I have a table that I want to drop and recreate along with all of it's data. How would I go …
9 replies
Viewing 15 topics - 991 through 1,005 (of 17,082 total)
You must be logged in to create new topics.