Topics
Started by
Posts
Last post
I've been searching for pointers on SELECT..INTO vs INSERT..INTO around forums and the web and have…
11 replies
I'm trying to figure out how to return records from the previous month up to the 10th of that month…
3 replies
Hi there, we have several SSIS-packages on our SQL servers, usually stored in the msdb. In these pa…
2 replies
Please find the table structures as below USE Ticket GO CREATE TABLE Contact12 ( ContactID INT PRIM…
4 replies
Hello comunity I have create this function to return total pairs: CREATE FUNCTION [dbo].[fnQtRefCor…
3 replies
Doesnt sql server 2008 have a table type. i need to pass a table name into a proc.
5 replies
If this is covered somewhere else, sorry I did search though 🙂 I was looking for a specific value a…
1 replies
SERVER CONFIG: SQL 2008 Enterprise, 64-bit, SP2, latest updates, 4 CPU, 16GB RAM, RAID 1+0 I've got…
20 replies
I am trying to perform a query that takes the results of one query which joins a customer table a c…
9 replies
Suppose I have a variable which contains date value in a string format. eg: declare @value1 varchar…
16 replies
Hai friends create table company_order ( company varchar(100), location varchar(100), order_no …
6 replies
Hi, Using either HOLDLOCK or UPDLOCK as a lock hint allows other transactions to see the data, but,…
1 replies
Hi I have 100 or so users in a database but I need them all to have a server login also I was think…
8 replies
All, I am facing issue while using Right outer join in one of my queries (explained below using the…
2 replies
I have a table of dates similar to the attached. I can't change the table design (it's not my decis…
11 replies
Viewing 15 topics - 4,456 through 4,470 (of 10,636 total)
You must be logged in to create new topics.