Topics
Started by
Posts
Last post
Here's the table in question: PRICE_HISTORY prodid int, price float, timefrom datetime, timethru…
2 replies
Hi, I have 2 tables, JobApplicants and OpenPositions. JobApplicants looks something like this: Name…
10 replies
I am trying to do a full outer join as follows: select * from account &nb…
1 replies
Hi, Can I declare variables inside a view? I want to set the subquery result to a variable and us…
2 replies
I am looking for a lead or a psuedo sql to perform the following: I have a sales header and sales d…
6 replies
G'Day Everyone, I am looking for confirmation, and ideally a place in the documentation, that speci…
19 replies
Hi everyone im a newbie to this forum so please bear with me. Does anyone know how to use a between…
1 replies
Hello I need to update a field(column) with an id that looks like this: 1-FIT2 so that it does…
2 replies
I have a table date datetime text1 nvarchar text2&nb…
2 replies
Hello, I am using the following query; select count(*), convert(varchar,DateTime,101) from divuk gr…
1 replies
Hi All, I hope you all have a great day. I have a difficulty of deleting a row from a table. Pl…
2 replies
Hi I need some help, I need to create a Foreign key constraint that references to a table in …
4 replies
How can I modify the following so it will compare the 1stDate and 2ndDate fields, extracting the "m…
2 replies
I am fairly new to SQL Server and have not had many problems as of yet. However I am having an issu…
2 replies
I'm trying to write a cursor, here is the select: select sd.name from sysdatabas…
2 replies
Viewing 15 topics - 11,326 through 11,340 (of 17,082 total)
You must be logged in to create new topics.