Topics
Started by
Posts
Last post
This short piece of SQL gives "Invalid object name 'test2'. I can create table test but creating t…
3 replies
Hi, The following code is almost working, it selects everything I want but slightly too much. It i…
4 replies
Table is called drugs and is laid out like so: name dosage packsize aspirin 75mg …
16 replies
Hi All, I'm required to load multiple XML Files from one folder into a database table, I also need…
3 replies
Hi How would one programatically ORDER BY? This is what I am trying to do: declare @a as varchar(1…
3 replies
CREATE PROCEDURE [dbo].[Procedure_table] (@records INT OUTPUT, @location nvarchar(18) = NUL…
10 replies
Hi, I have two tables Projects and FundingSources How can i create a summary with each project per …
4 replies
Hello everyone. This is my first post. I think this a wonderful resource and I hope to answer othe…
5 replies
I have this query for marking duplicate rows. It works on a small database but takes more than 2 da…
5 replies
Is there a way to have short cut for Views. I do see for stored procedures... But not views. If not…
6 replies
I have four tables that have a varchar data type which gets imports or daily user updates and this …
8 replies
Hi all, If I have a job that executed twice, how can I, using t-sql, find which one executed last? …
6 replies
Hi all, Could someone help me make it work, please? I have the following case: create table t (col1…
2 replies
Hi, I have a Excel sheet with usernames, I would like to loop through the usernames and see what in…
4 replies
Hi all experts, My question is my do we need Partition function? What would have happen if microsof…
3 replies
Viewing 15 topics - 1,426 through 1,440 (of 5,050 total)
You must be logged in to create new topics.