Topics
Started by
Posts
Last post
drop table #product;drop table #category; Create table #product (productID int, Categories varchar(…
10 replies
Hi, Help me in below case. I would like to see the folder/file size from sql. is there is any exte…
1 replies
Hi folks, I have a query that works fine as a SQL query but I can't use it in the report builder pr…
4 replies
In my organization, we have several linked servers that we setup to join two different types of dat…
6 replies
Does anyone know if it's faster to do "order by" before creating a clustered index? ex) select COLU…
6 replies
Hi all, I have written a SP that selects records from a table (yup simple stuff). If the select sta…
2 replies
I have inherited a colleague's code & I recognize the test for day one of the month, but can s…
5 replies
Does anyone have a really good proper case function for peoples names? - I took a stab at one a lit…
6 replies
I am trying to select rows from a table using a column that I want to compare to another column but…
2 replies
Hi Guys, Can I have your assistance please. I'm trying to write the query below but I'm having issu…
5 replies
Hi there, In the code below the last SELECT statement gets a list of countries, with concatenated s…
4 replies
I have a table which has 1 crore + records. I need to select the records which has the createtime …
13 replies
I have a need to, based on a query, produce multiple csv files. I've created a sample table that r…
4 replies
I am trying to update the employee id in a table with data from another table using a cursor. I am…
6 replies
Hello, Anyone know if the above can be done? Pretty sure the answer is "no", but thought I'd ask t…
2 replies
Viewing 15 topics - 7,471 through 7,485 (of 12,230 total)
You must be logged in to create new topics.