Topics
Started by
Posts
Last post
Hello all, Forgive my ignorance but I am new to using Cursors in T-SQL. I thank you in advance for…
6 replies
Hi there, I want to check if a column exists in a table and if it does remove/drop it . So the dat…
2 replies
Is there any way to generate ER diagram using schema information? I can not use any third party too…
1 replies
I have a table that looks like the below (sorry for the horrible formatting). ID | Class | Date --…
3 replies
Right now I am doing it this way... and there must be a better way. select cContactID ,statuscode…
4 replies
The subject line says it all. I'm testing something in an UPDATE trigger. Basically, I'd like to do…
9 replies
hi all, i posted in here a week ago and got loads of responses ( thank you again) i was advised to …
9 replies
Hello, We have one report which send us daily created by SQL procedure. I am attaching image for th…
2 replies
Hi, I am not sure if this question belongs here, sorry if I am posting in the wrong sub-forum. I ha…
3 replies
Need query help for the following I have a sample data, as below on one of my table. ============ …
4 replies
Hello I have a query: select count(*) FROM F_POLICY_PREMIUM POLICY_DATA INNER JOIN D_PRO…
5 replies
Hello I am trying to exclude from my query rows where Code is either 'GST', 'TAX', 'COMM' and rows…
3 replies
I'm running 2 exact queries. One in production and one in dev. They both connect to the same LINKE…
6 replies
Good day! I want to get only the date part of a value from a datetime stored in the database. The v…
3 replies
I have 2 separate strings that are pipe delimited - Ex: '1|2|3|4|5' and 'AAA|BBB|CCC|DDD|EEE' I nee…
2 replies
Viewing 15 topics - 2,056 through 2,070 (of 4,984 total)
You must be logged in to create new topics.