Topics
Started by
Posts
Last post
I'm working with healthcare data, specifically with drug data. I've been supplied a reference table…
21 replies
I am struggling with an overview of jobhistory. I am so far as to convert job_runtime and job_runda…
2 replies
Hi, I am in need of converting a datetime column into character type and then sort it once it is co…
18 replies
Delete from t1 from account t1 join Resource t2 on t1.RID = t2.RID Hi All, The above query is del…
8 replies
Hi all How to get historys of users login in sql server 2008 user login time and log off time Than…
13 replies
Hello, I would like to sort letters before numbers. A letter can appear anywere within the varchar …
15 replies
Not sure how to create this report most efficiently in SQL Server 2008 R2. I have a table Initiativ…
4 replies
Hello I have a locking issue which I'm trying to resolve, we have a table which gets hit with a lot…
2 replies
Hi all, Currently, I suspect that there are records deadlock issue in my application. So, I use thi…
4 replies
Hi, I wanted to know if there is any way in T -SQL where we can execute >2 queries (Insert/Delet…
11 replies
Hi all, Kinda stuck on finding a way to optimise this solution. Let's say I have a table which cont…
12 replies
create table test (A1 int,A2 int) insert into test (A1,A2) select 100,1 insert into test (A1,A2) se…
7 replies
I have a problem with one of my scripts. I need to put an error log file on a file share. Part of t…
3 replies
I have a set of data from computer scans that I am storing in a single table. The data is cumulativ…
5 replies
hello guys, Is it true that when you created a table variable, and inserted a data on that table va…
2 replies
Viewing 15 topics - 1,621 through 1,635 (of 12,234 total)
You must be logged in to create new topics.