Topics
Started by
Posts
Last post
I have two tables. A lookup table that has a PK and various columns. Looks something like this: tbl…
7 replies
I have a simple query where I needed to see if a qty had decimal places. I was instructed to use fi…
2 replies
I am having an issue in which sp_getschemalock is running with a duration of >= 800ms any time I…
1 replies
I have the following tables: create table Cars ( CarID int, CarType varchar(50), PlateNo varchar(20…
4 replies
How to setup a monitoring where it throw an alert whenever a field data type value is about to reac…
4 replies
Dear Group: We get a daily push from other systems into our SQL Server for us to do reporting again…
2 replies
Hi, I required duplicate values in the below table For e.g staff date 10192 first record To date …
2 replies
Hi , I wrote a stored proc where I need to evaluate a bit flag and if true append "NOT IN" clause. …
4 replies
Hi, I wanted to do insert data from file into table without SSIS using select query instead of tabl…
10 replies
By: x
Hi, I have a sample data and table as: Field0 Field1 Field2 Field3 Field4 Field5 1000 Text1 Text2 T…
4 replies
as I'm not clear how to use bcp and bulk insert in the following cases, could you please give me an…
1 replies
Could you please me how checksum work in the SQL statement ? below is an example. SELECT * FROM Ta…
7 replies
I have a very simple query: SELECT AkcesAutoID FROM ( SELECT P.AkcesAutoID, A.AkcesitPred, A.…
22 replies
Tell me how to do it better. It takes to long to run. its because of the Totals by truck but I have…
3 replies
Is it good idea to add hint NOLOCK in Sales.SalesPerson for second example. Any references that tel…
47 replies
Viewing 15 topics - 1 through 15 (of 2,875 total)
You must be logged in to create new topics.