Topics
Started by
Posts
Last post
Im a junior data support analyst and trying to select records from a table with the column ErrorDat…
3 replies
Hello All,I have a simple stored procedure that inserts records into a table. Create proc Update_Re…
8 replies
Hi, I am new to using temp table and aware that they are created in Tempdb. However let us say if I…
4 replies
Hi-- please advise on the below sceanrio SELECT * --- Question ) How can I replace "*" which…
4 replies
I'm trying to find the correct way of using a subquery count to subtract from main query count... t…
4 replies
Hi, Below I have code that takes in 3 parameters. Now, sometimes, as you can imagine one of these c…
8 replies
Can anyone tell me whats wrong with the line with: FOR stateID in (36,11)?: SELECT * FROM ( …
2 replies
Hi, Sorry for my bad english. I need to select some rows of a table like that : Id Object | …
16 replies
My table and data as follow, USE [WeightManagement] GO /****** Object: Table [dbo].[crpt_NotaPenya…
6 replies
How do I get the records for the last 24 hours for each VisitID, based on the ActivityDateTime? So,…
4 replies
I have a question concerning the cross join in the following sql: SELECT a.SCHOOLYEAR, CASE when SU…
2 replies
Is there a way to open EDI file in SQL Server and insert the data into tables? Thanks.
32 replies
I want to perform something like.... SELECT * FROM a JOIN b ON a.geometryField = b.geometry…
2 replies
Hi Experts, Seeking help on a query. The query is used to take a min to get executed. But now, over…
4 replies
Hi All, Need some help in writing tsql query using which I should be able to tell what all records …
3 replies
Viewing 15 topics - 256 through 270 (of 4,984 total)
You must be logged in to create new topics.