Topics
Started by
Posts
Last post
I need query in following formatCustNo , YTDSales, PreviousYearSales, MTDSales I have q…
33 replies
By: below86
the syntax working with fixed date and time SELECT LAST_UPDATED_TIMESTAMP FROM WORKING_HRS WH…
3 replies
In t-sql-2012, I am trying to load all the schoolID values into the variable called @CalendarID.I t…
5 replies
By: Mike01
Need help in writing query. I table Requestdetails which contain the below data. Pkey RequestId …
4 replies
Hi Folks, I've been asked to make some modifications to the nightly data load jobs. We have h…
3 replies
I discovered something interesting today while trying to resize a VARCHAR column. Resizing fails wi…
4 replies
Hello. I'm trying to turn something like '{1,2,3,4,5}' into '1,2,3,4,5'. I can't be certain that th…
6 replies
I have two different tables in SQL. One of which records when a product was removed from being in u…
2 replies
Hi guys, I'm a bit confused as to what I'm doing wrong here. I've got a table type into which…
1 replies
By: NikosV
Hello! I am using SQL Server 2012 and my database is set to 'SQL Server 2000 (80)' compatibility le…
4 replies
Hi guys, I've read 2 or 3 articles on Multiple Joins but I'm still failing to understand exactly wh…
14 replies
How can I combine all the dates from #VISITS to each provider in #PROVIDER? create table #VISITS …
6 replies
By: NineIron
Hey guys,Got this table and I want to avoid inserting the same records.CREATE TABLE [dbo].[BR_LIMIT…
6 replies
By: DesNorton
Hello, I have a data set of unique_id by eomonth of everymonth since jul 2015 with a field aggregat…
10 replies
Create table #TEMP(ID INT) Create table #TEMP1(ID INT,Letter_Type&nbs…
6 replies
Viewing 15 topics - 541 through 555 (of 4,984 total)
You must be logged in to create new topics.