Topics
Started by
Posts
Last post
I am testing two examples in which a WHERE clause is compared to the results of a subquery. SELEC…
5 replies
I am testing the TRY_CONVERT( ). Here is my code: SELECT TRY_CONVERT(int, 'ABC') as Result;-- r…
5 replies
Hello Gurus I have a query that looks something like this delete a from table a inner join (select …
8 replies
I am testing on the AdventureWorks database (the OLTP version, not the data warehouse version). Th…
1 replies
I want this function to retrieve the latest buyer from two databases db1 and db2. It worked for a …
2 replies
I have this table: CREATE TABLE dbo.legalchanges ( userid bigint NOT NULL, TCChanges int NOT NULL…
8 replies
Hi all, Hopefully you can help me. I have created a sql job which returns some results and t…
1 replies
Hi Folks, I want to send a daily report with SQL Query For that, i have implemented a query to send…
8 replies
I came across this by chance when I was testing the assignment of variables. This SELECT query ret…
2 replies
A while ago, I was testing stored procedure return codes. I'm preparing for the 98-364 Database Fu…
12 replies
I am having a huge brain fart on how to accomplish what I want. I want to pivot the attached set of…
2 replies
Seems SQL Server doesn't have a regular expression function. I am trying to query for records in wh…
6 replies
I just started reading about the EXISTS operator. I have two examples. In both examples I have a …
3 replies
Greetings, I have the following Json document saved to a SQL table and am having issues parsing it …
3 replies
I created a table: CREATE TABLE dbo.orders ( ord_no int NOT NULL, purch_amt …
2 replies
Viewing 15 topics - 1,621 through 1,635 (of 1,791 total)
You must be logged in to create new topics.